Recently I read a discussion in a mailing list on how to execute large number of on-demand workflow and out of curiosity, I tried to look for the method that was discussed, which uses Microsoft Dynamics CRM for Outlook as elaborated here:
I tried that method with 7000 records and apparently it took long time for me to finish the operation and makes my Outlook application not usable for long period. So, I think there should be another way to do this, as I was presenting the SSIS toolkit in the last Melbourne CRM UG, I recalled that there’s “Execute Workflow” functionality in Kingswaysoft’s SSIS toolkit.
So out of my experiment, I set up a simple SSIS project to execute On-Demand Workflow on Contact record to give the value on email field:
And create a simple SSIS process as follow:
1. Contact Data Source:
2. Destination To Execute Workflow with Batch Size of 200 (I learned this batch size from SF, where their bulk operation is limited in 200 for performace, unsure about Dynamics CRM)
3. The Result
The whole operation that took hours when using Microsoft Outlook client, now accomplished within 4 minutes and 55 seconds (approximately 5 minutes)! It is accomplished with relatively simple and intuitive process.
Below is the result on contact records: