SSIS Package - Change connection property without opening package

• Loner

  SSC-Insane

  Points: 21279

  More actions

  September 12, 2013 at 8:57 am

  #298652

  I am using SQL Server 2008 SSIS.

  I used to have a DTS package using Dynamic property task so when I move from development to QA and to production, I don't need to open the package to change the database connection to different server and database.

  But now I am using SSIS, everytime I change the SSIS package and when I move it to QA and production, I have to open it to change the database connection,

  Is there a way to change the database connection without opening the package?

  Thanks

• herladygeekedness

  SSCertifiable

  Points: 5878

  More actions

  September 12, 2013 at 12:59 pm

  #1649844

  Yes, I use pkg configurations to define servername and databasename which I have dev values supplied for in the variables pane. On the server, I use Set Values tab to pass in local values - prod server and db name.

  I think there are many ways to do configurations, but I've not used the xml or file type, just this easy little parent variable method since I really only need a couple values.

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  September 12, 2013 at 1:04 pm

  #1649845

  Loner (9/12/2013)

  ---

  I am using SQL Server 2008 SSIS.

  I used to have a DTS package using Dynamic property task so when I move from development to QA and to production, I don't need to open the package to change the database connection to different server and database.

  But now I am using SSIS, everytime I change the SSIS package and when I move it to QA and production, I have to open it to change the database connection,

  Is there a way to change the database connection without opening the package?

  Thanks

  This article will be really helpful.

  Understanding Integration Services Package Configurations

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