Home

CRM SSIS Components for Dynamics 365

Install Requirements

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

Add SDK SQL Server SDK libraries referenced on the project, Verify added references properties 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
• CRMSSIS.CRMDestinationAdapter.dll
• CRMSSIS.CRMCommon.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