Share via

  • Article

DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMNS

Details

Product Name

SQL Server 

Product Version

10.0

Product Build Number

Event ID

-1071636243

Event Source

dtsmsg.rll

Component

Integration Services 

Symbolic Name

DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMNS

Message Text

Columns "__" and "__" cannot convert between Unicode and non-Unicode string data types.

Explanation

This message 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 columns, or vice versa.

The hexadecimal value for this error message is 0xC02020ED.

Possible Causes

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

  • You are using the Excel source and have not configured a Data Conversion transformation to convert string columns from the Unicode data that was loaded from the Excel source.

  • You are using the Excel destination and have not configured a Data Conversion transformation to convert to Unicode the data that is being saved to the Excel destination.

User Action

Add Data Conversion transformations to convert the data

Add Data Conversion transformations to convert string columns from non-Unicode (DT_STR) to Unicode (DT_WSTR) strings, or vice versa.

Use the SQL Server Import and Export Wizard to create the package

When you use the SQL Server Import and Export Wizard to create a package, it creates and configures any Data Conversion transformations that are required for you. Use the wizard to create a base package, save it, and then reconfigure and enhance it.