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 |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2015-04-01 : 20:47:34
|
| Hi Guys, I have two questions regarding SSIS Config file. 1) I have simple SSIS Package, however I am using three different SQL DB. I want to know should I have to create three different config file to store Username/p.w or I can create one config file?2) I want to know how this Config file working, Please correct me If I am wrong, my understanding is, in above example I create one config file to store SQL DB server user name and p.w and once I done build the SSIS Package. Now I want to move this package .dtsx package to network drive to excess/call package. At this point I dont haveto transfer my config file with .dtsx package because When this .dtsx package will execute it will read the config file where the package is reside, am i right?Thank You. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-04-06 : 12:19:25
|
| We use Data Sources inside the package. When scheduled as a job, the job step can override some of the settings, such as the server name. A config file with userid/password is a very bad idea. Use integrated security instead at the very least.You can also use the environment variables for SSIS projects.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SSIS .Config file question