I have a SSIS package (A) which calls a file system SSIS package (B) from an "Execute Package Task". The ConnectionString property for the file connection for (B) is set dynamically from a variable using an expression.
(A) fails with the following error when trying to call (B):
Error: Error 0x80070003 while loading package file "". The system cannot find the path specified. .
I've added a breakpoint on the PreExecute event for B to inspect the value stored in the connection string variable, and everything looks fine. When I take the value from the variable and search for the dtsx file in Windows I find it.
I've done this (calling a file system package from within another package) many times before. I've compared the settings with other packages where I've done this and cannot find a difference. I am sure I am missing something simple. Can anyone help?