how to call another SSIS package while passing arguments
Or you could use Sript task in the parent package to assign the value to a variable. In the child package set up another variable that reads the value from the parent variable in another script task.My Blog | Ask Me | Test your SSIS skills
June 14th, 2011 10:54am

I have a master SSIS package that runs certain execute sql tasks and based on the query results, it fires one of the other SSIS packages (child package) in the same solution. The execute SQL tasks in the child packages would take the case number that was used in the master package. How do a pass the case number as an argument to the child package? Thanks.
Free Windows Admin Tool Kit Click here and download it now
June 14th, 2011 11:56am

Use a Parent Package Configuration in the Child Package design. Use the EXACT SAME VARIABLE NAME so there is no doubt.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.
June 14th, 2011 12:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics