I want to create a variable that sets the file path of the child SSIS package. In the Expression tab of the Execute Package Task Editor (of the parent package), do I set the Connection property to the variable? I set a variable to the location of the package and package name. For example, PackagePth = C:\SSISPackages\Package1.dtsx. I assign PackagePth to the Connection property.
The error I get is "The connection C:\SSISPackages\Package1.dtsx is not found. This error is thrown by Connections collection when the specific connection element is not found. Error at Execute Package1 Package: The result of the expression "@[User:
ackagePath]" on the property "Connection" cannot be written to the property. The expression was evaluated, but cannot be set on the property."
I also tried to set the PackagePth variable to C:\SSISPackages\ and PackageName to another variable defined as Package1.dtsx. But that didn't work either.
Thanks for the help!