Link to home
Create AccountLog in
Avatar of cipriano555
cipriano555

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of cipriano555
cipriano555

ASKER

OK, thank you for your comment.