Update only connection information in ssis package

• swapnil.d13

  SSC Veteran

  Points: 213

  More actions

  November 25, 2011 at 1:11 pm

  #247398

  Update only connection information in ssis package

  Hi,

  I have created ssis package from code itself setting both source connection string and destination connection string also some other stuff in it.

  It works fine. But now I want to set diff. source connection string in ssis package like DBname, userid, password keeping other information as it is in run-time in code.can I update only source connection string in ssis package? Please help..

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  November 27, 2011 at 10:37 pm

  #1413237

  swapnil.d13 (11/25/2011)

  ---

  can I update only source connection string in ssis package? Please help..

  Yes, it is possible.

  Created package configaration file.

  Open your package in BIDS. Click on SSIS menu. Select "Package configuration..."

  Package cofiguration file (.dtsConfig) is a XML file. You can update the connection stgring in it directly using notepad.