If one package in my solution has protection encryptwithpassword, does the master package which calls all packages also need that protection level?
I have a master package with a sequence container inside it. Inside the container are three execute package tasks. All the packages including the master are set to DontSaveSensitive, except for one which is set to encryptwithpassword. When I execute the master, the first two packages are executed, but the last one fails. The master package has this message: Error: Error 0xC0012050 while loading package file " ". Package failed validation from the ExecutePackage task. The package cannot run. . and the package which fails has this message: Error: There were errors during task validation. Any ideas what can cause this?
October 26th, 2011 3:12pm

Sounds like a basic validation failure. In other words, the package does not even start to run; SSIS is still validating the package against the database. Open the package in BIDS and point it to the database that is uses when running from the Master package. See if presents any validation messages.
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2011 8:47pm

re-execute by setting the property DelayValidation = TRUE for the master package The error does not say it has anything to do with protection level
October 27th, 2011 4:34am

Normally the master package shouldn't have the same protection level, as you can specify the password for the child package inside the Execute Package Task. As no_prakash and Randy said, there is probably some other validation error going on.MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2011 5:41am

Normally the master package shouldn't have the same protection level, as you can specify the password for the child package inside the Execute Package Task. As no_prakash and Randy said, there is probably some other validation error going on.MCTS, MCITP - Please mark posts as answered where appropriate. Answer #1: Have you tried turning it off and on again? Answer #2: It depends...
October 27th, 2011 12:31pm

In this case we couldnt get the master to complete unless all the packages inside the master were set to encrypted w password as the protection level. thanks for all your ideas.
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2011 7:18pm

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

Other recent topics Other recent topics