SSIS

• karthik-472578

  SSC Enthusiast

  Points: 146

  More actions

  December 7, 2007 at 10:57 am

  #181220

  hi frnds,

  i have created 12 ssis packages pointing to development database, now i am moving all the packagse to live environment, i need to change the connection string for all the 12 packages, instead if i having a xml confiuration fie for connection it will be easy, can you ppl help me generate an xml file with source and destination creation and steps to follow.

  thank you

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  December 7, 2007 at 11:13 am

  #758183

  Try this: http://www.sqlservercentral.com/articles/Integration+Services/61619/

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  December 10, 2007 at 4:22 am

  #758526

  You can have Package configuration

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Peter Rijs

  Hall of Fame

  Points: 3400

  More actions

  December 17, 2007 at 7:24 am

  #760672

  I agree with Dinesh that you should look for package configuration, check out the BOL on this (for instance http://msdn2.microsoft.com/en-us/library/ms141132.aspx).

  You might also consider using a parent package with child packages, or configuring the packages at runtime by adding parameters to the dtexec command.

  All these options are explained in BOL, and elsewhere on the net.

  I shouldn't go with Steve's suggestion: as it was discussed in the forum it turned out to be a rather "quick 'n' dirty" solution, with a couple of pitfalls.

  Peter Rijs
  BI Consultant, The Netherlands

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  December 18, 2007 at 1:10 am

  #760911

  http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/