Now that I’ve moved to Windows XP, I’m trying to use SQL Server 2005 rather than install SQL Server 2000. Unfortunately SQL Server 2005 makes some things more difficult. For example, exporting a SQL Server database to Access 2003 can generate many errors. I recently encountered numerous errors about unicode string conversion:
Error 0xc02020f6: Data Flow Task: Column “PlayerID” cannot convert between unicode and non-unicode string data types.
(SQL Server Import and Export Wizard)
I was unable to find much help online in solving this problem but eventually I figured out how to create an Integration Service Project to deal with the errors.
Open Visual Studio 2005 – create an Integration Service Project. Open a SSIS package saved from the failed SQL Server Import and Export Wizard.
- Drag Data Conversion item from toolbox.
- Delete connection between Source and Destination
- Connect Source to Data Conversion
- Connect Data Conversion to Destination
- Double click Data Conversion
- Check off Available Input Columns
- Change data type to "Unicode string [DT_WSTR]"
- Rename Output Alias which will be named Copy of
- Click OK button
- Double click Destination. Select Mappings.
- Select Data Conversion 1.Field from Input Column
Data Flow
Data Conversion Transformation Editor
OLE DB Destination Editor – Mappings
