DTS Calling Package from another package | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Calling Package from another package

Hi. I have been struggling with this problem for some time and it appears to be a bug with DTS.
I am calling a package from another package. I have a Success and Failure path from the ‘Execute Package Task’ step in the Parent package. However, if the Child package fails (the file it is trying to load is locked), the Parent package still goes down the Success path! Any ideas? Any help will cure my headache! Jaswinder Singh
A K ITech Limited
London, UK
May checkhttp://www.windowsitpro.com/SQLServer/Article/ArticleID/6196/6196.html this link to solve the issue. Also check the DTS log for further information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.