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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics