I have problem, when tryin to export data from SQL Server 2005 using Integration Services.
Sql Server has collation SQL_Latin1_General_CP1_CI_AS (code page 1252), but the actual data is encoded using code page 1257 (SQL_Latin1_General_CP1257_CI_AS). When I look the data using Management Studio, it is displayed wrongly, but when I convert the string
to binary, I can see that bytes are encoded using code page 1257. I'm trying to read this data using SSIS 2005, but extended characters are always handled wrongly.
How should I read this data using SSIS?
My first assumption was changing DefaultCodePage to 1257 in my OLE DB Source component (also AlwaysUseDefaultCodePage to true). But without luck.
Also tried to convert data in my SQL Server query using COLLATE, but didn't work.
Is there something I could do to get it working?
View Complete Post