Click here to Skip to main content
14,735,478 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
Hi All,

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,

Nagaraj
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900