Deploying SSIS package with configuration file
Posted on 2014-02-17
I deployed an SSIS package from my development machine to the server where it will run via management Studio. Then I manually copied the configuration file to the target server. When executing the package via Management Studio I specified the path to the config file on the target server (the one I copied manually) but when the package ran, it was looking for the configuration file path from my development machine. I do not even think it used the config file I copied, but rather data sources i specified before runnign the package.
My question is how do I deploy the configuration file along with SSIS package and prevent the package from trying to reference the old config file from the development machine?