DTS_E_CONNECTIONNOTFOUND

Details

Product Name

SQL Server 

Product Version

10.0

Product Build Number

Event ID

-1073676274

Event Source

SSIS

Component

Integration Services 

Symbolic Name

DTS_E_CONNECTIONNOTFOUND

Message Text

The connection __ is not found. This error is thrown by Connections collection when the specific connection element is not found.

Explanation

The package cannot run because the specified connection manager cannot be found.

The hexadecimal value for this error number is 0xC001000E.

Possible Causes

This message might appear because of one of the following problems:

  • The logging configuration for the package does not specify a connection manager.

  • An Integration Services component or feature specifies a connection manager that has been removed from the package. This can occur when you copy tasks and other components from one package to another package.

User Action

Depending on why the specified connection manager cannot be found, you might have to take one of the following steps:

  • Specify a connection manager for the package log. To specify a connection manager, in Business Intelligence Development Studio, in the SSIS Designer, on the SSIS menu, click Logging.

  • Verify that the package contains the specified connection manager. To verify that the package contains the connection manager, confirm that the connection manager appears in the list in the Connection Managers area. The Connection Managers area appears on the Control Flow, Data Flow, and Event Handlers tabs of the SSIS Designer.