DTS SSIS- Task Script and Threading?

I have written a task script using vb.net that have thre开发者_高级运维ad used in the code, the problem is how i can know when will be finished all the threads so i can return the success result.

Thanks alot.

i think you need to use a waitHandle object and the waitAll method

more info here: http://msdn.microsoft.com/en-us/library/system.threading.waithandle.aspx

That being said, I suspect you can refactor the design of your package to let the script task handle the execution, and let SSIS handle the execution scheduling. this gives you the parallelism you want without any of the hassle of multi threaded programming in .net.

a simple setup would be n foreach loops (which execute in serial) each running a partitioned chunk of the work load.

Another simpler option is have the package driven by variables and spawn multiple executions of the package. This could occur across 1-N servers to scale out.