• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 52
  • Last Modified:

SSIS Doesn't keep changes in properties

I’m needing to create 3 versions of an SSIS 2012 solution, dev, prod, and test. The only difference between the three is that any connection manager that points to a database needs to point to its corresponding database.  So the prod OLE DB connections need to connect to the prod data base, test needs to connect to test, etc.  I copied the solution folder and contents to get 3 copies. I change the database names in the appropriate places.  Save the file.  When I reopen, they are back to the original values, changes are not saved.  How to make the changes hold?

I see other people on the web reporting this problem.  I don’t understand the responses they are getting.

Thanks,

Cipriano
0
cipriano555
Asked:
cipriano555
1 Solution
 
Anthony PerkinsCommented:
I’m needing to create 3 versions of an SSIS 2012 solution, dev, prod, and test.
In a word: Ouch.

Don't do that, that is going to be a maintenance nightmare.  Instead create a single package and set your connection string using an expression instead.
0
 
cipriano555Author Commented:
OK, thank you for your comment.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now