Hi, I have SSIS package which has some out file path say "M",this SSIS package I use for production sql server.
Now I need to perform some testing on other sql test server...,I have changed output file path say "K" in the same SSIS package whic I was using in productin but when I run my test ... the output file is appearing on at path "M" and not "K". After I run my test on test server I am looking forward the output file on path "K"
Do I need to change the path anywhere else also?
You should only have to change the file connection manager. If you are running the SSIS package within a job you will have to reimport the package to your SQL Server. If you are running it in BIDS then you should just have to change the file connection manager and test the package.
answered Feb 10, 2011 at 08:14 AM
Check for Package Configuration files. It doesn't matter what you change the file connection manager to, if there is a package config file it will revert to the saved connection on runtime.
If there are config files, you may have to tweak them for a dev and prod environment. Config files are a fantastic tool, but they can be dangerous if the are not handled properly.
answered Feb 10, 2011 at 03:34 PM