How to use solution-level configuration to dynamically change SSIS package OLEDB connection in design time

Question

I am modifying an SSIS project that our company took over from another vendor. I can see that for the existing projects, when I change the solution configuration, all the OLEDB connection server names are changed. Specifically, if I change the solution configuration from "production" to "staging", all the connections change from production server to staging server.

I can't figure out how this is done. I've been searching MSDN, Google, etc. for some time, and all the posts point me to the package configuration, but that is not what the project is doing, because all the existing packages have the option "Enable package configurations" turned off.

Does anyone have any ideas? Any help will be very much appreciated!

Is your Connection Manager ConnectionString property configured through a User defined variable? Here is how to check: Opposite click MyConnectionManager > Properties > Expand Expressions > ConnectionString > @[User::MyConnectionString] — Jon Jaussi
– Jon Jaussi, Commented Dec 22, 2013 at 14:16
Thanks for replying!My connection managers for the OLEDB connections are all using shared data sources defined for the packages. — user1289470
– user1289470, Commented Dec 23, 2013 at 17:46

Mike Honey · Accepted Answer · 2014-01-14 04:09:54Z

1

From your description I think you are seeing Visual Studio Configurations at work. These can store a discrete version of each Data Source's connection string definition (in the .dwproj file). Visual Studio magically swaps these in and out as you change the Configuration selection.

This is not related to the package configuration, which will actually override whatever you see in the Visual Studio UI at runtime. This can be very confusing.

answered Jan 14, 2014 at 4:09

Mike Honey

15.2k1 gold badge29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use solution-level configuration to dynamically change SSIS package OLEDB connection in design time

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related