Execute Package Task

[rsx]

Hello, I have a master package that calls other packages. One of these children packages is password encrypted. I have entered this password into the Execute Package Task editor in the master package. However, when I run this task it fails when calling the password encrypted package with the following error:

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

Can anyone help or provide a work around?

Thank you.

 

[Catadmin]

What kind of password encryption? Owner or User?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Catadmin]

DOH. That was a DTS question I posted.

What kind of encryption are you using on your SSIS package? Both the Parent and the Child. Who owns both packages? What account(s) are being used to run them?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[rsx]

Hello Catadmin, thanks for responding! I have just found an article that solves this problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=241941&SiteID=1

apparently the password encryption is irrelevant.

Hope this helps!