«
»

Error exporting data to UTF8 in SQL Server DTS

Error 0x00470d4: Data Flow Task 1: The code page on input column “COLUMN_NAME” (111) is 1252 and is required to be 65001.
(SQL Server Import and Export Wizard)

Usually this error appears when the table has a data type of VARCHAR, what you need to do is to change it NVARCHAR.

, , ,

This entry was posted on Wednesday, June 16th, 2010 at 9:16 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

  1. #1 by kk on April 6th, 2011 - 10:41 pm

    Error when trying to export data in UTF-8 fromat (1252 and is required to be 65001)

    Reply Quote
(will not be published)
Submit Comment

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word

Subscribe to comments feed
  1. No trackbacks yet.

SetPageWidth