Skip to content

Home

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

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.

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

On SSIS Proyect

Debugging Properties Run64bitRuntime =False

Clone this wiki locally