Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 How to move a config file to a different location

Author  Topic 

BMF
Starting Member

4 Posts

Posted - 2010-07-26 : 01:37:25
Hello All,

I need help on moving a .config file in SSIS to a different folder. How would I perform this task without breaking the existing process? Also how would I test it to make sure it works without executing the package?
Please advice.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2010-07-26 : 05:02:50
You can move the .config file to another location and update the calling job/command to reflect this change, during a time when the package is not running.

You can use the Execute Package Utility, dtexecui to review the command line.
Ensure the the folder/file permissions are set correctly.

The best way to test the change is to run the package - in a DEV/TEST environment.
Go to Top of Page
   

- Advertisement -