Custom ConnectionManager always returns null at runtime

Question

I have written a very simple custom connection manager inheriting from ConnectionManagerBase. My acquireconnections and release works as it should in design time on my source component. The issue is when I try and execute it in Visual Studio. I associate my connection with my component in design time and the value persists as it should. But when my source component calls acquireconnection and then checks the RuntimeConnectionCollection[0].ConnectionManager, it is always null. During design time it is there and establishes a connection fine but for the life of me I can't figure out what I am missing to make it work during run time. I know it has to be something simple but I have read code for ssis connection managers and source/destination components until I am blue in the face and can't see what I am missing. Does my savior exist on this forum? I am running Visual Studio 2019 with 3.12 of SSIS plugin. Framework version is 4.7.2 to compile on any cpu. Please let me know if anyone has any questions about anything and I am happy to answer.

Answer 1

I have a similar issue with a custom source component, still haven't found an answer. Any update?

Answer 2

Unfortunately, I was not able to figure this one out. I am confident it has something to do with my development installation/setup and not a code issue as it was a bit of a maze trying to figure out what components to install to get it all working. Since I didn't hear back from anyone with any information that was helpful, and it was more than painful making SSIS do something it probably shouldn't in my circumstance, I decided to abandon that customization and handle it a different way. Good luck on your finding a solution!

Answer 3

Hi,

We are facing exactly the same issue trying to create our own ConnectionManager with a VS 2019 and VS2022.

Did anyone found a solution ?

Regards

Gautier