asked
I have a SSIS Package that Imports Data from a CSV file and dumps it into a SQL Table. Package works fine but the Issue is it imports Symbol £ as ú
Hi, My Flat FIle Source's Column Data Type is string [DT_STR] and the Destination datatype is varchar(50) Can you please advise. Regards, Maulin.
Two options. 1. It's a collation/code page issue. What collation is in use on your database and field? what code page is in use on the server? what about on the client machine that generates the input? 2. It's a font issue; the data's fine, but being mangled on display. What font is being used? Does the font have the £ sign in it? edit - Thinking about it, there's a third option: both the above are causing problems.
The file is generated from our ERP System. The Data in the Database is not showing the Symbol correctly, what does Font has to do with that ? I have records in another table with £ sign in it. Collation is: SQL_Latin1_General_CP850_CI_AS
@ThomasRushton got this one. Your collation specifies codepage 850 which gives ú an integer value of 163 and £ an integer value of 156. Codepage 1252 gives £ an integer value of 163 while ú has an integer value of 250. It appears that your SSIS package, source file and/or operating system may be using codepage 1252 or something compatible while the collation on your column uses different integer assignments, so the characters get transposed Try selecting the column with a different collation to see if you see the £: SELECT [column_name] COLLATE SQL_Latin1_General_CP1_CI_AS as [name_wanted] Codepage 850:
http://www.ascii.ca/cp850.htm Codepage 1252:
http://www.ascii.ca/cp1252.htm
16 People are following this question.
