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

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS .Config file question

Author  Topic 

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 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.

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 Kizer
SQL Server MVP since 2007
Go to Top of Page

- Advertisement -