5

I get this error on a File Destination Task, do you know what the cause is and how to fix it ? 

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at export data to csv [Flat File Destination [187]]: The code page on input column "..." (958) is 1252 and is required to be 65001.

ta

user3752281
  • 163
  • 1
  • 2
  • 5

2 Answers2

11

The issue is caused by a clash in code pages between 1252 (i.e. Windows-1252) in SQL Server and 65001 (i.e. UTF-8) that your CSV file is expecting.

I believe one solution to the issue would be to CAST your source columns to NVARCHAR in the initial SELECT from the database, or use a Data Conversion task to convert them to Unicode strings.

An alternative would be set the code page in the Flat File Connection Manager to 1252 ANSI - Latin.

Mark Sinkinson
  • 10,657
  • 4
  • 47
  • 54
0

I had the same issue where My error was as follows:

The code page on Flat File Destination.Inputs[Flat File Destination Input].Columns[Number] is 65001 and is required to be 1252.

Then I was doing google and I found very interesting and correct results from the below website: Here in the question, itself answer is given. After that, I just change code-page-1252 in flat-file property from connection manager and it worked for me

Manoj Jha
  • 1
  • 1