I am only trying to copy a whole table into a flat file, with column names and all. I made a blank txt file and assigned it a connection manager. Then I connected the source
table to a FF destination.
The flat file destination has the error -
Error 8 Validation error. Data Flow Task Flat File Destination : The code page on input column "My_Code" (56) is 1252 and is required to be 65001. Package.dtsx
I don't know why this happens and how to fix it. Please help me to fix this.
Guess what ! I figured it out accidentally while thinking about it. Solution -
Go to the connection manager of FF. Your code page will be 65001 ie UTF-8. Set it to 1252 ie ANSI - Latin I.
Then, if you see a warning, reconnect the two components.
What happened, why it happened,I have no clue.