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 |
|
zion99
Posting Yak Master
141 Posts |
 Posted - 2008-07-07 : 00:44:58
|
| Hi,I have created a SSIS package and added Connection managers to it. Also, I have added some config files so that i can make DB changes when required without making changes in the SSIS package.The issue is when i execute the package utility, it takes the details from the connection managers & NOT the config files. Please let me know what changes needs to be done so that whenever the package is executed it obtains Server & DB details from config files & not from the connection manager. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-07 : 03:48:56
|
| How have you set the configuration properties for package? |
 |
|
|
zion99
Posting Yak Master
141 Posts |
Posted - 2008-07-07 : 05:26:11
|
| yeah, using the Execute package utility...i added the required config files using configurations options. But still it doesn't work.surprisingly, before adding the config files, this tab are was empty though i had checked the 'Enable Package Configurations' checkbox in the SSIS file. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-07 : 05:39:03
|
| one of methods:-http://www.mssqltips.com/tip.asp?tip=1405 |
|
|
|
zion99
Posting Yak Master
141 Posts |
Posted - 2008-07-08 : 01:04:52
|
| thxn a ton visakh16 :), this method rocks... |
|
|
|
|
|
|
SSIS package not using config files