config file
Hi,I would like to put the ssis package from Dev to Prod environment.How should the config file be configured so that I do not have to change anything while going from Dev to Prod? At present in Dev, I have a path in the config file which looks at the database in Dev.I can change this to point to live when moving to production but is there an easier way so that I do not have to make any changes when going from Dev to Prod please? Thanks
September 5th, 2008 5:11am

You're always going to have to make some changes while going migrating between environments. What you describe is the correct use for config files. You can also look into: Creating a deployment utility, which is like an installer for your packages which will promt for new values during deployment and make the changes for you dtexec.exe (the command line utility used to execute SSIS packages) supports the /CONFIGURATION option to pass in custom configurations at runtime as well the /SET option which allows you change indivual properties of package objects at runtime e.g. db name (acts just like a single entry from your configuration file)
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2008 5:35am

There is now an utility available in CodePlex which can be used to batch update SSIS Package Configuration File paths without using BIDS: http://ssisconfigeditor.codeplex.com/
May 19th, 2012 2:28am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics