Our SSIS pacakges is structured as one management pack and many child packages (about 30) that are called from the management pack. Baby packages are called using the Run Package task. For each child package, there is one Run Package task. Each Execute package task uses a file connection manager to indicate the path to the dtsx file of the child package. There is one file connection manager per child package. Each file connection manager has an expression defined for the ConnectionString property. This expression is as follows:
@[Template::FolderPackages]+"MyPackage.dtsx"
The file name for each package is different. The variable (FolderPackages) is specified in the SSIS package configuration file.
An error that occurs at runtime
Error 0x80070002 when loading the package file "MyPackage.dtsx"
The system cannot find the specified file. "A package that fails is different from starting to start, and sometimes packets are not dropped at all. This is done under the same environment / data, etc.
I started FileMon during this error and found out that when an error occurs, SSIS tries to read the dtsx file due to the wrong location, namely from system32. I checked that this is similar to what happens if the variable @ [Template :: FolderPackages] is empty, but since the same variable is used for each child package and works for some, but sometimes it doesn’t work for others, I don’t have an exception to this fact.
Anything obvious or time to call support with Microsoft?