I am using Visual Studio 2017 (SSDT).
I have several packages (about 50) I need to migrate to use the project deployment model (instead of package deployment).
I created a new Project and added my first SSIS package. I converted the existing database connection manager to Project connection and everything worked fine.
I then added my next package to the project. I can see 2 connection managers in the package. 1 being the existing Package connection and the other being the Project connection manager I just created.
Since both connection managers point to the same database, is there a way I can just swap the existing package connection manager with my new Project connection manager so that I won't have to go into all the different tasks in the SSIS package and update them to use the Project Connection manager as this would be very time consuming and prone to error?
I did some research and the best I could find was an article on updating the SSIS packages in a text editor by doing a find and replace. I'm hoping there is an easier more automated way of making the change within Visual Studio? Anyone have any suggestions?
In case it helps anyone:
I would have thought this could be done natively within VS without having to edit the package XML.