SSIS Main Package throwing Error : Package Failed Validation From Execute Package Task

2
votes

i have a Main Package and 2 child packages(Load and Export). i have both child packages on the server in shared folder. when i execute Main Package its giving me the following Error for one of the Child package.

Error: Error 0xC0012050 while loading package file "\mhfile02\DIRFILEDEV\CHG77253\SSIS Packages\AaeAutoenrollee_Load.dtsx". Package failed validation from the ExecutePackage task. The package cannot run. .

Can anybody tell me what could be wrong?

Thanks

5
ssis
Almost anything. It could be that there's an error in the package. It could be that the package can't find something it needs to find like a connections or a config file or table. Failing validation is a very generic error in SSIS. – Jeff Hornby

5 Answers

1
votes

Are you running the package via SQL Server Agent?

Try running the child packages individually, it may be throwing other errors. If the package runs without error, the problem is probably on the Main package settings.

Some questions that may help you? 1. when you loaded the packages to the server, did you set any Protection Level (eg encrypt sensitive data with key, user key, etc?) setting these can make a package fail loading when run via SQL Server Agent 2. Try adding /msdb/ to the path of the child package.

0
votes

If you are connecting in the child package to an Excel file, and you set on the child solution property page Under - "Configuration Propeties" "Debugging" the variable "Run64BitRunTime" = False You have to do it also on the Parent Package!

0
votes

This error message means that your child package will not pass the validation. Check your child package to see if there's any task inside that does not pass the validation (a red cross appears beside it).

Maybe you have something being dynamically created that is used in such task (like constructing the connection string at runtime for some connection manager). Try set this task's DelayValidation property to True.

0
votes

From one day to another, I got this error in Visual Studio / SSDT too (VS 2013, with SSIS 2014). Note: I have project deployment model, not package deployment. I have ProtectionLevel = EncryptSensitiveWithPassword.

In the master package, on all package execution tasks, I had to retype the password for the sub-packages again. After that, it worked again. I guess the master package had some corruption, no idea why.

Greetings, Roli

0
votes

If you are connecting in the child package to an Excel file, then set DelayValidation = False on the child package excel connection manager.