Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2011-11-18 : 14:00:09
|
| Hi guys,I've got the following problem I cannot figure out:I have an SSIS package (let's call it SSIS_child) with a database connection and 2 variables (ServerName and DatabaseName).The database connection has 'Expressions' set where InitialCatalog is mapped to 'DatabaseName' variable, and ServerName is mapped to 'ServerName' variable. I set the values of these variables and run the package and it works with no problems.Since I want this SSIS_child to run as one of the components of a larger package, I created a 2nd package (let's call it SSIS_parent). This package also has 2 variables (ServerName and DatabaseName). All this SSIS does is call SSIS_child, passing the variable values from parent package to the child package (this is achieved by enabling package configurations of SSIS_child and adding these 2 variables with configuration type 'Parent package variable').I now run SSIS_parent, which is supposed to just take the variable values, pass them to SSIS_child and then run the package. The run fails with the following message:"Error: Error 0xC0012050 while loading package file "C:\SSIS_CHILD.dtsx". Package failed validation from the ExecutePackage task. The package cannot run.".Please advise.Thank you! |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2011-11-18 : 15:58:52
|
| Simply re-creating the parent package in exactly the same way solved the problem - not sure why.I suspect something is stored internally in SSIS, and although visually 2 packages look same, the code behind it does not seem to be the same.Thanks! |
 |
|
|
|
|
|
Child package successful, but parent package fails