Share via


Errors and Events Reference (Integration Services)

This section of the documentation contains information about several errors and events related to Integration Services. Cause and resolution information is included for error messages.

For more information about Integration Services error messages, including a list of most Integration Services errors and their descriptions, see SSIS Error and Message Reference. However, the list currently does not include troubleshooting information. For general troubleshooting guidelines, see Troubleshooting (Integration Services).

Important

Many of the error messages that you may see when you are working with Integration Services come from other components. These may include OLE DB providers, other database components such as the Database Engine and Analysis Services , or other services or components such as the file system, the SMTP server, or Microsoft Message Queueing. To find information about these external error messages, see the documentation specific to the component.

Error Messages

Symbolic name of error

Description

DTS_E_CACHELOADEDFROMFILE

Indicates that the package cannot run because a Cache Transform transformation is trying to write data to the in-memory cache. However, a Cache connection manager has already loaded a cache file into the in-memory cache.

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Indicates that the package cannot run because a specified connection failed.

DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN

Indicates that a data flow component is trying to pass Unicode string data to another component that expects non-Unicode string data in the corresponding column, or vice versa.

DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMNS

Indicates that a data flow component is trying to pass Unicode string data to another component that expects non-Unicode string data in the corresponding column, or vice versa.

DTS_E_CANTINSERTCOLUMNTYPE

Indicates that the column cannot be added to the database table because the conversion between the Integration Services column data type and the database column data type is not supported.

DTS_E_CONNECTIONNOTFOUND

Indicates that the package cannot run because the specified connection manager cannot be found.

DTS_E_CONNECTIONREQUIREDFORMETADATA

Indicates that SSIS Designer must connect to a data source to retrieve new or updated metadata for a source or destination, and that it is unable to connect to the data source.

DTS_E_MULTIPLECACHEWRITES

Indicates that the package cannot run because a Cache Transform transformation is trying to write data to the in-memory cache. However, another Cache Transform transformation has already written to the in-memory cache.

DTS_E_PRODUCTLEVELTOLOW

Indicates that the package cannot run because the appropriate version of SQL Server Integration Services is not installed.

DTS_E_READNOTFILLEDCACHE

Indicates that a Lookup transformation is trying to read data from the in-memory cache at the same time that a Cache Transform transformation is writing data to the cache.

DTS_E_UNPROTECTXMLFAILED

Indicates that the system did not decrypt a protected XML node.

DTS_E_WRITEWHILECACHEINUSE

Indicates that a Cache Transform transformation is trying to write data to the in-memory cache at the same time that a Lookup transformation is reading data from the in-memory cache.

DTS_W_EXTERNALMETADATACOLUMNSOUTOFSYNC

Indicates that the column metadata in the data source does not match the column metadata in the source or destination component that is connected to the data source.

Events (SQLISPackage)

For more information, see Understanding Events Logged by an Integration Services Package.

Event

Description

SQLISPackage_12288

Indicates that a package started.

SQLISPackage_12289

Indicates that a package has finished running successfully.

SQLISPackage_12291

Indicates that a package was unable to finish running and has stopped.

SQLISPackage_12546

Indicates that a task or other executable in a package has finished its work.

SQLISPackage_12549

Indicates that a warning message was raised in a package.

SQLISPackage_12550

Indicates that an error message was raised in a package.

SQLISPackage_12551

Indicates that a package did not finish its work and stopped.

SQLISPackage_12557

Indicates that a package has finished running.

Events (SQLISService)

For more information, see Understanding Events Logged by the Integration Services Service.

Event

Description

SQLISService_256

Indicates that the service is about to start.

SQLISService_257

Indicates that the service has started.

SQLISService_258

Indicates that the service is about to stop.

SQLISService_259

Indicates that the service has stopped.

SQLISService_260

Indicates that the service tried to start, but could not.

SQLISService_272

Indicates that the configuration file does not exist at the specified location.

SQLISService_273

Indicates that the configuration file could not be read or is not valid.

SQLISService_274

Indicates that the registry entry that contains the location of the configuration file does not exist or is empty.