I have a parent package (Pack-A)that executes two or more instances of the child package(Pack-B) parallely, Pack-A is scheduled to run using SQL Agent.
Child packges are executed using DTS API and Threading.
I have a script task in Child Package which executes the another package.
All the pacakges are getting executed successfully when there is only one instance of the child package.
Example: Pack-A Is Running , Pack-B Is Runing (Single Instance)
If two or more child packages are executed in parallel, the first instance of the child package is getting finished successfully. Remaining packages are failing as they are trying to give call back to first instance.
I think that Task GUID and Package GUID is creating issues here.
Is there any way to isolate the child package instances execution?
Packages are developed using VS 2005.
Thanks In Advance,