Ssis Connection Not Found in Package

SSIS Connection not found in package

It seems that your ssis package is pointing to some other connection which might have been deleted or renamed .Try opening the SSIS compoenents and point to the correct connection which are there in your connection manager .

It happens when we copy the SSIS package components to create a new package or because of renaming the connections or there may be still components which are using the old connection defined in you xml config file( In your case try checking the Execute SQL Task which is throwing error ) .If you are using XML for configuration try deploying the new one.

The connection is not found. SSIS

You can view and edit dtsx file as regular XML file. So, open it and find

<DTS:ConnectionManagers>
    <DTS:ConnectionManager ... DTS:ObjectName="CM name"> 

if you are using SSIS 2012+
or

<DTS:ConnectionManager>
...
<DTS:Property DTS:Name="ObjectName">CM name</DTS:Property>

if you are on SSIS 2008.

Remove node <DTS:ConnectionManager> and save the file.

SSIS Connection Manager Does Not Exist

You will need a ConnectionManager. It's an object in your project (assuming you are working in a project...) which you can add. This ConnectionManager can then be modified in order to not use a static connectionstring but to use a variable instead. This string variable as you already mentioned has then to be populated with the correct string. This can be done within your script task

How can I find a missing Connection String in my SSIS Package?

The connection manager must be referenced somewhere or it wouldn't be throwing that error. In my experience this should result in a red X being shown somewhere in the solution either during the design or when you try to execute it. A commonly missed place is in event handler tasks since they don't jump into view when you run the solution.

If you know which package is causing the error you can right click the package in the solution explorer and select "View code". Then do a text search for the offending GUID. DTSX files are just XML. I wouldn't recommend manually deleting the text but you should be able to identify which element is referencing the deleted connection manager.

---

Related Topics