Bulk Execute On-Demand Workflow with Kingswaysoft SSIS

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:

http://www.powerobjects.com/blog/2013/07/30/run-on-demand-workflow-in-dynamics-crm-250-records/

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:

Sample_Workflow

And create a simple SSIS process as follow:

1. Contact Data Source:

SourceEntitySourceEntityColumns

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)

ExecuteWorkflowKingswaysoft

ExecuteWorkflowKingswaysoftColumnMapping

3. The Result

7000Records Complete

Performance

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:

ContactBefore ContactAfter

 

 

 

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s