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.
| Author |
Topic |
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
 Posted - 2009-02-20 : 09:42:27
|
| I have a package now, which reads the records from 2 OLE DB sources and creates 2 separate Flat Files. Then on completion as a trigger, I have to copy these files from the DataBase Server to the application Server.The filenames along with the path are defined as variables so that they can be changed in the Config file when the code is being promoted to every environment.The problem now is, there is a different team that does these promotions and changing the Config file is a manual process for now. This leads to error most of the times when there is a typo in the path or the server name.Is this the right way of doing this? Is there any other way to do this apart from setting variables and changing them in config files? |
|
|
|
|
|
Config file changes