Errors and Events Reference (Integration Services)

 

Applies To: SQL Server 2016

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 Integration Services Error and Message Reference. However, the list currently does not include troubleshooting information.

System_CAPS_ICON_important.jpg 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.

Symbolic name of errorDescription
DTS_E_CACHELOADEDFROMFILEIndicates 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_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGERIndicates that the package cannot run because a specified connection failed.
DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMNIndicates 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_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMNSIndicates 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_CANTINSERTCOLUMNTYPEIndicates 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_CONNECTIONNOTFOUNDIndicates that the package cannot run because the specified connection manager cannot be found.
DTS_E_CONNECTIONREQUIREDFORMETADATAIndicates 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_MULTIPLECACHEWRITESIndicates 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_PRODUCTLEVELTOLOWIndicates that the package cannot run because the appropriate version of SQL Server Integration Services is not installed.
DTS_E_READNOTFILLEDCACHEIndicates 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_UNPROTECTXMLFAILEDIndicates that the system did not decrypt a protected XML node.
DTS_E_WRITEWHILECACHEINUSEIndicates 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_EXTERNALMETADATACOLUMNSOUTOFSYNCIndicates 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.

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

EventDescription
SQLISPackage_12288Indicates that a package started.
SQLISPackage_12289Indicates that a package has finished running successfully.
SQLISPACKAGE_12291Indicates that a package was unable to finish running and has stopped.
SQLISPackage_12546Indicates that a task or other executable in a package has finished its work.
SQLISPackage_12549Indicates that a warning message was raised in a package.
SQLISPackage_12550Indicates that an error message was raised in a package.
SQLISPackage_12551Indicates that a package did not finish its work and stopped.
SQLISPackage_12557Indicates that a package has finished running.

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

EventDescription
SQLISService_256Indicates that the service is about to start.
SQLISService_257Indicates that the service has started.
SQLISService_258Indicates that the service is about to stop.
SQLISService_259Indicates that the service has stopped.
SQLISService_260Indicates that the service tried to start, but could not.
SQLISService_272Indicates that the configuration file does not exist at the specified location.
SQLISService_273Indicates that the configuration file could not be read or is not valid.
SQLISService_274Indicates that the registry entry that contains the location of the configuration file does not exist or is empty.

Integration Services Error and Message Reference

Community Additions

ADD
Show: