SQL Server Performance

dynamic connection

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Aug 7, 2007.

  1. fmardani New Member

    SSIS packages are now created and tested against dev sql server.
    Now I would like them all to point to the live sql server.
    What is the best way to have the connection dynamic?
    Obviously I prefer not to go through each package and change the connection manager.
  2. satya Moderator

    Why to point them from dev. server to live server, why not create them on production server and execute locally?
  3. dineshasanka Moderator

    best is to use package configurations.
    You can save all your settings in XML file and chnage those files when required.

Share This Page