Skip to content

Home

Jump to bottom
Couchiman edited this page Apr 1, 2018 · 20 revisions

CRM SSIS Components for Dynamics 365

**This are a basic Connection Manager and Source Adapter. ** **Destination Adapter is still pending task.

SQL Server 2016 SQL Server 2014 SQL Server 2012

Install Requirements

Need SQL Server Client SDK Installed. You can found it on SQL Server installation DVD or ISO.

Add SDK Server SDK libraries referenced on the project, Verify added references propertities to be:

**Copy Local = false ** Embed Interop Types= false

Restore Nuget packages Dynamics CRM 365 version 9.007

Register in GAC - you could open "Developer Command Prompt for Visual Studio xx":

ex: gacutil.exe -iF "YOURPATH\CRMSSIS.CRMConnectionManager.dll"

  • CRMSSIS.CRMConnectionManager.dll
  • CRMSSIS.CRMSourceAdapter.dll
  • Microsoft.Xrm.Sdk.dll
  • Microsoft.Crm.Sdk.Proxy.dll
  • Microsoft.Xrm.Tooling.Connector.dll
  • Microsoft.Xrm.Tooling.Connector.dll
  • Microsoft.Xrm.Sdk.Deployment.dll
  • Microsoft.IdentityModel.Clients.ActiveDirectory.dll
  • Microsoft.IdentityModel.Clients.ActiveDirectory.WindowsForms.dll

Use SQL Server Directory version

130 for SQL Server 2016

120 for SQL Server 2014

110 for SQL Server 2012

Fast deploy example for SQL Server 2016:

gacutil.exe -u CRMSSIS.CRMConnectionManager gacutil.exe -iF "C:\CRMSSISRepo\CRMConnectionManager\bin\Debug\CRMSSIS.CRMConnectionManager.dll"

copy "C:\CRMSSISRepo\CRMConnectionManager\bin\Debug*.dll" "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Connections" /y copy "C:\CRMSSISRepo\CRMConnectionManager\bin\Debug*.dll" "C:\Program Files\Microsoft SQL Server\130\DTS\Connections" /y

gacutil.exe -u CRMSSIS.CRMSourceAdapter gacutil.exe -iF "C:\CRMSSISRepo\CRMSourceAdapter\bin\Debug\CRMSSIS.CRMSourceAdapter.dll" copy "C:\CRMSSISRepo\CRMSourceAdapter\bin\Debug*.dll" "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents" /y copy "C:\CRMSSISRepo\CRMSourceAdapter\bin\Debug*.dll" "C:\Program Files\Microsoft SQL Server\130\DTS\PipelineComponents" /y

gacutil.exe -u CRMSSIS.CRMDestinationAdapter gacutil.exe -iF "C:\CRMSSISRepo\CRMDestinationAdapter\bin\Debug\CRMSSIS.CRMDestinationAdapter.dll" copy "C:\CRMSSISRepo\CRMDestinationAdapter\bin\Debug*.dll" "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents" /y copy "C:\CRMSSISRepo\CRMDestinationAdapter\bin\Debug*.dll" "C:\Program Files\Microsoft SQL Server\130\DTS\PipelineComponents" /y

gacutil.exe -u CRMSSIS.CRMCommon gacutil.exe -iF "C:\CRMSSISRepo\CRMSSIS.CRMCommon\bin\Debug\CRMSSIS.CRMCommon.dll" copy "C:\CRMSSISRepo\CRMSSIS.CRMCommon\bin\Debug*.dll" "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents" /y copy "C:\CRMSSISRepo\CRMSSIS.CRMCommon\bin\Debug*.dll" "C:\Program Files\Microsoft SQL Server\130\DTS\PipelineComponents" /y copy "C:\CRMSSISRepo\CRMSSIS.CRMCommon\bin\Debug*.dll" "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Connections" /y copy "C:\CRMSSISRepo\CRMSSIS.CRMCommon\bin\Debug*.dll" "C:\Program Files\Microsoft SQL Server\130\DTS\Connections" /y

On SSIS Proyect

Debugging Properties Run64bitRuntime =False

Clone this wiki locally