Skip to content

Home

Jump to bottom
Couchiman edited this page Sep 21, 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 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

Images

CRM Connection Component

CRM Destination Adapter

CRM Mapping Window

CRM Source Adapter

Flat File to CRM Destination Deployment. Includes successful outputs and error outputs

Clone this wiki locally