• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1416
  • Last Modified:

Error 3Validation error. DataFile: Flat File Destination [1917]: The code page on input column "XXX" (1937) is 65001 and is required to be 1252.

Hi Experts,
I see this error for the flat file destination- "Error 3Validation error. DataFile: Flat File Destination [1917]: The code page on input column "XXX" (1937) is 65001 and is required to be 1252", please let me know what could be the cause
0
shyamaladevib
Asked:
shyamaladevib
1 Solution
 
brad2575Commented:
This would be the a property of the source and/or destination.  If you click Properties on either one there is a "CodePage" property half way down.  The 1252 is the default, the other one is a differnt type.  You will most likely have to use a "Data Conversion" step between the source and destination to convert the source to the same "CodePage" as the destination.
0
 
shyamaladevibAuthor Commented:
Hi, Thanks for the response, I had to use data conversion in the beginning and again change it back before I get to the destination and that worked.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now