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