Empty connection managers when deploying SSIS packages unless converted to Package Connections

Question

This is my first time starting from scratch with the "new" SSIS Integration Services Catalogs introduced in SQL 2012. I've developed packages with this new model for years but never set up my own environment.

I have packages that work in Visual Studio 2019 just fine and have project connection managers that will span across all of the packages in this project. When I deploy the packages the connection managers are empty in the package configuration.

Here's my project with the connections setup.

And here's what it looks like when I deploy the packages using the Project connections

If I change the connections to "Package Connections", the connections deploy as expected.

When I do this, the connection managers is populated

What am I missing?

Answer 1

Notice the Scope - GetWorkerData.dtsx That's showing you what is configurable at the scope of the package. Since the connection managers at that point are Project level, you need to change the Scope to something different (I don't have a project level CM handy). Alternatively, right click on the project "Pull Data from ADP" and select configure from there. Then it will pop open that wizard with the correct scope selected.