question

sam21 avatar image
sam21 asked

SSIS XMl Config Multiple connections

Hi, I have one configuration file that I want to use for multiple packages. However these packages have a few common connections and a few connection manager which are not common among them. So while I execute the package I am getting error that connection can not be found. Error: The connection "" is not found...... So, is it a must that all connection that I specify in the config file should be present in all packages? or there is a workaround? any help appreciated..
sql-server-2008ssisconfiguration
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sam21 avatar image
sam21 answered
I guess I have to Use two (or more than two) config files , one would be shared (with the shared elements) whereas the other will only bear the "unique" entries.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.