Missing "Convert to Package Connection" in SSIS's "Connection Managers"

Question

Hi all,

I am new to SSIS and following the Tutorial below to learn it. However, I can't get through it.

https://learn.microsoft.com/en-us/sql/integration-services/lesson-2-adding-looping-with-ssis?view=sql-server-ver16

In Lesson 2-3: Modify the Flat File connection manager, it asked to right-click Sample Flat File Source Data, and select Convert to Package Connection. However, in my environment, there is no "Convert to Package Connection" function under Connection Managers. Because of it, I cannot find the variables node in expression builder.

Does anyone experience it and how to fit it? Here below is my environment:

• SQL Server 2022
• Visual Studio 2019
• SQL Server Integration Services Projects V4.5

Answer 1

Hi @Kinson Lam,

If you could only see Convert to Package Connection when right-click the source, it means it is a package level connection manager, you may skip the step and choose Properties window for Expressions.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi Zoe,

I found what's wrong in my side. In fact, there is no context MENU available in Connection managers under Solution explorer of Visual Studio 2019. Instead, the context menu of "Convert to Package Connection" is under Connection Managers pallet.

Thanks your help and I spot it from the image you posted.

Answer 3

There is no context MENU available in Connection managers under Solution explorer of Visual Studio 2019. Instead, the context menu of "Convert to Package Connection" is under Connection Managers pallet.