CODEWITHSUNDEEP
ssisssis-2008
izikandrw
izikandrw

Reputation: 1883

SSIS 2008 Execute Package Task Connection Expression not valid

In SSIS 2008 I am trying to configure a package to execute another package using the Execute Package Task. In the Execute Package Task Connection expression I am using a variable that contains the absolute path to the folder where the package I want to execute is located because as we all now relative paths don't work in SSIS. The expression evaluates to what looks to be the right path as can be seen in the screenshot below. enter image description here

However when I try to execute the package I get the following error that it can't find the package:

enter image description here

I am very confused by this because the package path is correct. Any ideas?

Upvotes: 3

Views: 1084

Answers (2)

Tak
Tak

Reputation: 1562

I think you are setting the connection in the wrong place.

You need to set the connection string in the connection manager.

Example that I want to change the Package1.dtsx to execute Package2t.dtsx ..

Created Connection Manager "Package1.dtsx" that references a package in a folder called Package1.dtsx

Properties of Connection of Package1.dtsx in Connection Manager

Change ConnectionString in Connection Manager to execute Package2t.dtsx.

Upvotes: 1

Vinnie
Vinnie

Reputation: 3929

Try including double quotes since your file path string has spaces in it

"\"" + @[User::RootFolder] + "\\" + "ImportSessionAndSubsessions.dtsx\""

Upvotes: 0

Related Questions