Share via

  • Article

DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN

Details

Product Name

SQL Server 

Product Version

10.0

Product Build Number

Event ID

-1071636234

Event Source

dtsmsg.rll

Component

Integration Services 

Symbolic Name

DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN

Message Text

Column "__" 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 column, or vice versa.

The hexadecimal value for this error number is 0xC02020F6.

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.