Cause and Resolution of Integration Services Errors

New: 17 July 2006

This section of the documentation contains cause and resolution information for several errors related to Integration Services.

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.

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.

Summary of errors Description

Connection required when requesting metadata

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.

Product level is insufficient

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

Connection manager not properly installed

Indicates that SSIS Designer has encountered an error involving Registry permissions while enumerating the connection managers installed on the computer.

Could not load file or assembly

Indicates that the Script task or Script component cannot locate an assembly that is referenced within the script project.

Cannot convert between Unicode and non-Unicode strings

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.

See Also

Other Resources

Integration Services Error and Message Reference
Troubleshooting Integration Services

Help and Information

Getting SQL Server 2005 Assistance