Home Forums SQL Server 2005 Business Intelligence What is the best way to make SSIS execute package task connections portable ? RE: What is the best way to make SSIS execute package task connections portable ?

  • Thank you for your reply. The MSDB solution sounds like the best option.

    I have tried the following solution with packages on the file system:

    I use a global variable (vRootFolder) containing the path to the folder containing the packages and include this variable in a general configuration shared by all packages. Then I go in the connection's properties and use the expression builder to dynamically build the conn. string. with something like @[User::vRootFolder] + "\\MySubPackage.dtsx". It works well but I would like to use replace the "\\MySubPackage.dtsx" litteral with something dynamic like the connection name property. Any ideas ?

    Chris