Cannot convert between Unicode and non-Unicode strings

  • Article

New: 17 July 2006

Details

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399

Event ID

1. 0xC02020ED (-1071636243)

2. 0xC02020F6 (-1071636234)

Event Source

Not applicable

Component

Integration Services

Symbolic Name

1. DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMNS

2. DTS_E_CANNOTCONVERTBETWEENUNICODEANDNONUNICODESTRINGCOLUMN

Message Text

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

2. 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.

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.