"Package Failed Validation" error

I'm trying to have a parent package derive the filename for the appropriate child package to execute. The parent package logic manipulates a Filename variable that is then used in the connection string of the Execute Package task: "c:\\Packages\\" + @.[User::Filename]
The error I'm getting is Error 0xC0012050 while loading package file "c:\Packages\test.dtsx". Package failed validation from the ParentPackage task. The package cannot run.
How can I resolve this security/authentication problem?
Why I'm trying to do this? I'm importing dozens of different flat files. Some of the files share a generic import package, but many use their own custom import packages. I've not found a reasonable way to do this kind of branch from within the Control Flow of the parent package. I'm eager for suggestions though!

Thanks

TGrant wrote:

I'm trying to have a parent package derive the filename for the appropriate child package to execute. The parent package logic manipulates a Filename variable that is then used in the connection string of the Execute Package task: "c:\\Packages\\" + @.[User::Filename]
The error I'm getting is Error 0xC0012050 while loading package file "c:\Packages\test.dtsx". Package failed validation from the ParentPackage task. The package cannot run.
How can I resolve this security/authentication problem?
Why I'm trying to do this? I'm importing dozens of different flat files. Some of the files share a generic import package, but many use their own custom import packages. I've not found a reasonable way to do this kind of branch from within the Control Flow of the parent package. I'm eager for suggestions though!

Thanks

Hi,
You can place expressions onto the precedence constraints in your control-flow. This allows for conditional execution of tasks which sounds as though its what you're looking for.

You may want to explore the Foreach loop container which enables you to carry out the same procedure on a collection of files one at a time. (Here's a demo of how to do this: http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx) You can place your conditional logic (as described above) within the Foreach loop container.

Also, if you want to process multiple files which have the same format in exactly the same way, consider using a multiflatfile connection manager!

Hope this helps.|||Is the package available at the time of validation? It may be that the error is telling you that it cannot load the child package. That will fail validation. There are a few things you can do if this is the case, but the easiest is to set "DelayValidation" equal to true on the ExecutePackage task.
There should be a valid package there when validating though.