Configuration question

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  August 22, 2008 at 4:05 pm

  #123974

  Hi,

  I am developing packages in development -testing environment, then I need to deploy this to UAT environment and then to production. The connection string uses sql server authentication and they have same user name but different password. I have 15 packages to deploy, basically I am converting legacy to SSIS.

  How do I have take care of this issue. I know, configuration file can do this..But confused about the configuration files..getting different error..

  Thanks,

  VG

• Sarang Bobde

  Mr or Mrs. 500

  Points: 534

  More actions

  August 22, 2008 at 4:50 pm

  #862153

  You are right. You have to use XML configuration.

  Check this

  http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  August 22, 2008 at 4:59 pm

  #862155

  Yes...I found that link too....It is really good...and I got it working my SSIS packages...

  Thanks for your feedback...

  Have a nice week-end

  VG