Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ANSWERED - Flat file problem - input column is 1252 and is required to be 65001 Expand / Collapse
Author
Message
Posted Friday, October 04, 2013 3:56 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
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 [16]: 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.
Post #1501782
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse