CODEWITHSUNDEEP
visual-studio-2010ssisdynamics-crm-2011crm
Alex Gordon
Alex Gordon

Reputation: 60691

Speeding up an SSIS data import

I am using this resource to help speed up the process of deleting records from CRM:

http://danielcai.blogspot.com/2012/02/improve-crm-data-load-performance-by.html

And specifically this section:

enter image description here

I am trying to follow this advice:

In order to make full use of the BDD component, you need to increase the connection limit that is imposed by Microsoft .NET framework, which is a maximum of 2 connections per host (e.g. server) for service calls as far as CRM platform is concerned. In order to overwrite this limit, you need to modify DTExec.exe.config and DtsDebugHost.exe.config files under DTS\binn folder by adding the following connectionManagement section.

But I am unable to find the config files. I don't know so much about deploying the solution; however, even after trying to deploy it, I did not see a config file being created:

enter image description here

Here is the output I got from SSIS:

enter image description here

In case this is of any help, here's what my topology looks like": enter image description here

How do I speed up the deletion of records out of CRM using SSIS?

Upvotes: 0

Views: 457

Answers (1)

billinkc
billinkc

Reputation: 61211

dtexec.exe and DtsDebugHost.exe will live in the DTS\Version\Binn folder where Version - 110 = SQL Server 2012 - 100 = SQL Server 2008 and SQL Server 2008 R2 - 90 = SQL Server 2005

For 64 bit machines, there will be two flavors of the executable. Assuming installation to the default location, you may find them at

32 bit location

  • C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn
  • C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn
  • C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn

64 bit location

  • C:\Program Files\Microsoft SQL Server\90\Tools\Binn
  • C:\Program Files\Microsoft SQL Server\100\Tools\Binn
  • C:\Program Files\Microsoft SQL Server\110\Tools\Binn

For 32 bit machines, please destroy your machines and update to 64 bit architecture. That said, your file locations will be the same as the 64 bit locations above.

Upvotes: 3

Related Questions