Multi-Threading using conditional split
Any update is taking a long time to complete - we have 4 CRM webservice port/url. So using conditional split control in ssis to send updates to four engines.
During runtime it displays how mnay rows are being sent to each engine. In the log file I noticed a warning:
Configuration from a parent variable CRMServiceURL1 did not occur because there was no parent variable collection. I get the same with CRMServiceURL2 and three.
Would this mean my multi-threading is actually failing?
July 15th, 2011 9:49am
Apparently you have a problem propagating a variable from a child package to the parent or vice versa.
See this article to fix: http://consultingblogs.emc.com/jamiethomson/archive/2005/03/17/SSIS_3A00_-Passing-variables-between-packages.aspx
Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 15th, 2011 10:22am