April 1, 2015 at 6:47 pm
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 have
to 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.
April 2, 2015 at 2:48 am
1. Depends. If the 3 SQL DBs are on different machine, you can just use one config file but you change the values when you switch machines. If the 3 databases are on the same machine, you need 3 config files and you send the correct one along when you start the package. Or if you need to access the 3 databases at the same time, you can just use one config file with 3 seperate configurations (assumuing you have 3 connection managers).
2. If you move the package, the package still needs to be able to find the config file. If the config file is for example at D:\Config\Config.dtsconfig, the package at the new location will look for a config file at the same path. Relative paths are tricky, I think you need BIDSHelper to work with these.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply