DTS package run by SSIS package

[jeevdba]

I am quite new to SSIS but inherited a package written by my predecessor to maintain. The SSIS Mater pckage runs nearly 6 to 7 DTS packages within it. DTS Package A was one of the child packages run within the Master package. This package A is available in the Legacy folder in the SQL 2005 installation of ours. I had to do a modification to this DTS package, whcih I did and and then saved it back to the legacy folder in the SQl Server. When I run the SSIS Master package it fails at the point when it tries to run this DTS Package A saying that it expects a different package ID. Can somebdoy help me as to how I can recover from this situation please.

Thanks

Jeev

 

[MDXer]

Let me first be upfront and state I don't run dts packages through SSIS so this is pretty much an educated guess.

It sounds like you need to remap the task that is calling the child. When you edit DTS packages they store a guid value as the package ID this can be viewed by looking at the package properties. THis error leads me to believe that SSIS is actually using this GUID to call the package but since you child package has a new ID it is blowing up.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[jeevdba]

Yes you are right. Infact I knew about the Package GUID thngy. I entered the new GUID into the DTS child package properties and saved the SSIS package and ran again but was still trying to look at this package with the old GUID. Only later onto realise that there was a dtsconfig file that had the DTS child package GUID setting for this package A. When the SSIS master package was run it was looking at the config file for the DTS sub package's GUID. Changing the config file with the new DTS package GUID resolved the problem.

Many thanks again.