Error using Execute Package Task

I'm trying to run a package from another package using Execute package task -

I'm getting the error:

Error: Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run. .

I have Delay validation on the child package. Any other suggestions?

Thanks

I am perhaps wrong about this but I don't think setting DelayValidation=TRUE on the package prevents tasks from getting validated. If you have tasks that you don't want to validate when the package starts then set DelayValidation=TRUE on the TaskHost.

-Jamie

|||

I have every task/step in the child package set to delay validation. I can run it stand-alone no problem - just can't get it to run from another package

|||

A shot in the dark but do you have DelayValidation=TRUE on your connection managers as well?

-Jamie

|||I set them as well. I also tried disabling every step in the control flow of the child package and I still got the error|||

Then I can only think that one of your tasks is failing validation when it comes to execute. If this is the case you should have more details in the package log if you have one. And if you don't, you probably should.

-Jamie

|||

Not sure this helps much - I get the OnPostValidate and then the OnError with message that I mentioned at the beginning?

OnPostValidate,SARASINXPLT,VISIBILITY\sarasin,Payroll Stage,{AA054E03-67C2-4511-898E-58706A82A16B},{5F75D1F4-52F4-47CF-85B0-9F5542364939},2/9/2006 8:56:55 AM,2/9/2006 8:56:55 AM,0,0x,(null)

OnError,SARASINXPLT,VISIBILITY\sarasin,Payroll Stage,{AA054E03-67C2-4511-898E-58706A82A16B},{5F75D1F4-52F4-47CF-85B0-9F5542364939},2/9/2006 8:56:57 AM,2/9/2006 8:56:57 AM,-1073602332,0x,Error 0xC0012050 while preparing to load the package. Package failed validation from the ExecutePackage task. The package cannot run.

|||

I had an identical scenario. The package would run standalone; however, I could not run the package from another package. I had DelayValidation=TRUE at the package level and all tasks in the package were DelayValidation=FALSE.

My resolution was to set DelayValidation=FALSE at the package level and to set DelayValidation=TRUE for all the tasks.

|||Thanks GoZags! I had the same issue and I struggled for hours this morning before coming across this post - I just wish I had looked here sooner, it would have saved me a ton of frustration!|||

To All:

We were getting the same error message.

However, we discovered that it was the result of setting up our package to run on an environment variable, creating the environment variables on the target SQL Server machine, but failed to restart SQL Server Services so that it would be aware of the new environment variables.

DOH!

|||

GoZags, Jamie thanks for your imput, this bit of information has helped me as well, it solved the error above.