Finding Bad Connection SSIS

Question

Stuugie 50 Marketing Strategist

11 Years Ago

Hi All,

With SSIS, upon load, I am receiving the following error:

Error 1 Error loading DownloadCSVPackage.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Projects\EconAnalysisStatsCan\EconAnalysisStatsCan\DownloadCSVPackage.dtsx 1 1

I have gone through all of my connections to find that bugger that has a "" for a connection name but cannot locate it. Can anyone suggest a way, perhaps through VB and BIDS, to find that bad connection and then delete it? I want to go live with this but cannot until I find and remove this bugger. Any and all help is always appreciated.

mssql sql

2 Contributors
3 Replies
146 Views
2 Hours Discussion Span
Latest Post 11 Years Ago Latest Post by Stuugie

Reverend Jim 4,966 Hi, I'm Jim, one of DaniWeb's moderators.

11 Years Ago

I'm confused. Are you looking through your code to determine where the fault is?

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Stuugie 50 Marketing Strategist · Answer 1 · 2013-06-11T17:24:10+00:00

I don't have code that is looking for the bad connection. Sorry for the confusion. When I open the package, I immediately receive the error that the connection "" has not been found. I was hoping to run some code to find that connection and delete it if possible.

Stuugie 50 Marketing Strategist · Answer 2 · 2013-06-11T17:49:41+00:00

I'm starting to look through the XML portion of my package and I'm hoping to find the error there. LoL, there's over 30,000 lines so this may take me a while.