Posted on 2012-04-02
I have a development warehouse database and staging database refered to as db1. The databases is loaded with SSIS PACKAGES refered to as ssis 1.
I have created another warehouse database and staging database of the same schema refered to as db2. I did not want to re write the packages ssis1 so i coped them from the project folder and pasted them in a new folder. i then created a new projected ssis2 and added the existing packages using the wizard. The problem i am having is when i amend the connections in ssis2 to point database db2 it updates the original packages (ssis 1) as well as ssis2!
is this a bug in ssis or am i doing something wrong, what is the correct way of repointing the connections?