Hi there, I just created my first SSIS package as described in other thread. I used package configuration file for the connection string, Now i have deployed the package on staging as sql server package. Do i need to upload the package configuration file also on the server? If yes then what should be the location of the file? Best Danny
You can deploy the SSIS package in different ways and if you use .manifest to deploy it will create the configuration file. If you just copied the .dtx file or copied ssis package to msdb then you need to copy the config file too...you can keep your config where ever you want but it is better to keep all SSIS package files and config files at one place... When you are running the package as a job or in SSMS you can use different config files as needed. You can use multiple config files for single SSIS package.
Yes you need to transfer the xml config file to the production server. most reliable method is using, xml config files and environment variable. You can use environment variables to store the location of the config file more details at http://204.9.76.233/articles/dba/package_configuration_2005_p1.aspx