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 ?

  • You could use a configuration table and store your connectionstrings there. That way, every connection is in the same place and easy to view.

    But, if you have dozens of packages, I would recommend storing the packages in the MSDB folder on SQL Server. That way you can use relative paths and you even don't have to change them when changing environments. (except for the connectionstring to MSDB of course).

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP