Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Setting Connection in Execute Package task Expand / Collapse
Author
Message
Posted Monday, February 25, 2013 8:06 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 13, 2014 11:28 AM
Points: 99, Visits: 309
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::PackagePath]" 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!
Post #1423626
Posted Monday, February 25, 2013 8:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:36 PM
Points: 2,818, Visits: 2,565
Do you have "Delay Validation" set to True for that connection?
Post #1423632
Posted Monday, February 25, 2013 9:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, October 13, 2014 11:28 AM
Points: 99, Visits: 309
No, I don't. Does that property mean that it will not validate the expression during compile time, but until run time?

Should I set the connection variable to the dtsx (C:\SSISPackages\Package1.dtsx)? Or to C:\SSISPackages\ and then set the PackageName property to Package1.dtsx?

Thanks.
Post #1423668
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse