Connectionmanager is null

Here are the options to do this:. Configure at design time. Configure at run time. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Note If the data source is Microsoft Office Excel or Microsoft Office Access , the data source requires a different data provider than earlier versions of Excel or Access.

Note If the data source is Microsoft Office Excel , the data source requires a different connection manager than earlier versions of Excel. It is this line if ComponentMetaData. ConnectionManager is always null. All my reading says the reason this happens is the developer has not set the connection during design time but that isn't the case. I can set the connection manager on my component, save and reopen visual studio and it saves fine.

Then debug in design time and the connection establishes. Only during runtime does it not work. Please save me.

Monalv-msft I have provided the code as requested. Honestly I think you will find there is nothing wrong with my code but maybe I am wrong.

I am starting to feel like it is something to do with version or cpu targeting. I have tried a lot of different things though and don't want to spend anymore time guessing since this has been figured out times over.

I have a little more information to provide. I tried to get an excel connection manager working and was getting similar behavior to my custom so I googled the error what solved it for someone was going to the project properties of the SSIS project under debugging and select false under Run64BitRuntime. That fixed the excel connection manager issue so I figured it was related so I tried mine and got a new error. Cannot find the connection manager with ID in the connection manager collection due to error code 0xC Now I get an error and it can't debug because I assume the execution never starts.

My breakpoint is never hit that I set on pre execute and I get that error in the progress tab. The link below is someone who has the exact same issue that I am having. Creating a custom connection manager and getting the error above. I found many reasons the error above can surface but the OP below is the only reference to my exact same issue. The solution was to downgrade SSDT from 17 to He was using VS I am using and there doesn't appear to be a stand alone installation of SSDT so not sure what version VS ships with.

So I haven't tried this yet but wanted to get some feed back from someone hopefully as I believe this is my issue. Any ideas? Could easily be a race condition. It is not safe to assume that if connectionManager. To access the connectivity manager you need to add the permission in the Manifest file.

How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 6 years, 10 months ago. Active 3 years ago. Viewed 5k times. NullPointerException at com. Improve this question. Mihai Boisteanu. Mihai Boisteanu Mihai Boisteanu 1 1 gold badge 4 4 silver badges 14 14 bronze badges.