Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

These are the requirements that I want to complete:

a. I want the package to only use connection managers that are project/not package bound.

b. I also want these connections to be bound to the ssis config so that I can migrate these packages and they will connect to the correct environment seamlessly

c. I want to make sure this will work for pre-validation runs of the package so that it will validate its meta data against the db in the config rather than the hardcoded values in the package

So, my questions/concerns are:

How could I make my connection managers Project and NOT package specific?

I want to take these project specific connection managers and relate them to SSIS configurations

Is there a way to have both SSIS configuration (Config Tables) and store those values in an Environment Variable?

Any help is well appreciated. I know project bound connection managers are available in SSIS 2012, but i'm looking for an equivalent method in SSIS 2008

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.