Data Sources in Configuration Files
Hello,
In an Integration Services project, I can see there's a section for Data Sources which is used for defining shared data sources for all the packages. In addition, each package can define connection managers of its own, and these managers can be configured
using configuration files for the packages. My question is whether I can also use the configuration files to configure the shared data sources and how.
Thanks.
November 2nd, 2010 5:04am
Shared Data Sources are only shared for the development lifecycle and so once packages have been deployed, the data source/connection manager becomes stand alone for that package. In other words, if you have 2 packages using a shared data source,
once they have both been moved to a server, each package will have its own copy of the connection.
The way to manage shared connections is through configurations which you seem to be aware of. If you name the connections the same in each package then you could use a single configuration to manage the connection string for multiple packages.
HTH!every day is a school day
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2010 5:29am