CODEWITHSUNDEEP
ssiskingswaysoft
user2425239
user2425239

Reputation: 19

Kingswaysoft SSIS create Contacts Slow

I’m currently doing some testing for an upcoming data migration project and came across Kingswaysoft which seemed like it would be ideal for this purpose. However I’m currently testing importing 225,000 contact records into a new sandbox Dynamics 365 instance and it is on course to take somewhere between 10 and 13 hours. Is this typical of the speeds I should expect or am I doing something silly? I am setting only some out of the box fields such as first name, last name, dob and address data. I have a staging contact SQL database holding the 225k records to be uploaded. I have the CRM Destination Component setup to use multi threading batch size of 250 with up to 16 threads. Have tested using both Create and Upsert and both very slow. Am I doing something wrong - I would have expected it to be much quicker.

Upvotes: 0

Views: 1227

Answers (1)

Daniel Cai
Daniel Cai

Reputation: 446

When it comes to the data load to Dynamics 365 Online, the most important aspect that affects your data load performance is the network latency. You should try to put the data migration solution as close as possible to the Dynamics 365 online server. If you have the configuration right, you should be able to achieve something like 1m to 2m records per hour. The speed that you are getting is too slow. There must be something. There are many other things that could affect the data load performance, but start from network latency first. We have some other tips shared at https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/help-manual/crm/advanced-topics#MaximizedPerformance, which you should check out.

Upvotes: 1

Related Questions