SSIS: How to move a project connection manager into package

Question

I have a 2012 SSIS project with many connection manager defined at project level. The project also includes many packages having a reference to these connection managers. Now I want to convert my project to a deployment model but the wizard specifies that I need to remove connection managers at project which means moving the connection managers into packages.

How can I move the project level connection managers to my package?

Answer 1

You will need to convert the project from the Project Deployment Model to the Package Deployment Model.

From your description, you are seeing errors like this

This means you need to go into each package (sorry) and for every connection manager that indicates it's a (project) level one, you will right click and request that it be converted to a package level.