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.