Clever Geek Handbook

SSIS 2008 Execute Package Session Error

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 statement, I am using a variable that contains the absolute path to the folder where the package I want to execute is because since all other relative paths do not work in SSIS. The expression evaluates what looks like the right way, as shown in the screenshot below. enter image description here

However, when I try to execute the package, I get the following error, it cannot find the package:

enter image description here

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

+3


source to share


2 answers


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

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

An example of what I want to modify Package1.dtsx to do Package2t.dtsx ..



Created a "Package1.dtsx" connection manager that references a package in the Package1.dtsx folder

Package1.dtsx connection properties in connection manager

Change the ConnectionString in Connection Manager to execute Package2t.dtsx.

+1


source


Try including double quotes as the file path string contains spaces



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


source






More articles:


All Articles