Nov 13, 2013

Error at Package: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.

In general cause of this error is connection name you have specified is doesn’t exist.
May be you are assigning a value to a property which is file path or connection string but that property may accept name of connection instead of file path or connection string.

For example
In case of File System Task suppose you have assigned the property
Source = "C:\SSIS" or
Destination = "D:\Destination"

But both Source and Destination property doesn't accept the path. It accept connection name. So you will get error: Error at Package: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found.

Solution:
To resolve this issue you may have to first create the connection. In this example:
Right click on Connection Manager and select New File Connection.








We will get File Connection Manager Editor. Select the Usage Type and Folder.



Now assign Source = <Connection_name>. In this example:
Source="SSIS"

If you want to create dynamic Source then open properties of File Connection and in the expression set the Connection String property. 

1 comment:

  1. Anonymous4/28/2014

    Thanks, was helpful.

    ReplyDelete