Post reply

Collation problem, exporting data to a flat file

  • July 29, 2010 at 8:42 am

    #235857

    Hi,

    I have a table with collation SQL_Latin1_General_CP1_CI_AS and i want to export from this table to a txt file with encoding : l'ISO-8859-1.

    i get this error in my ssis data flow task as :error : code the column 1252 , must be 28591.

    how can i solve this? can i change the collation during an export ? I can't change the collation of table because it is related to other tables and it may produce some problems.

    thanks in advance for your help.

  • August 1, 2010 at 10:43 am

    #1200770

    nailosuper (7/29/2010)

    Hi,

    I have a table with collation SQL_Latin1_General_CP1_CI_AS and i want to export from this table to a txt file with encoding : l'ISO-8859-1.

    i get this error in my ssis data flow task as :error : code the column 1252 , must be 28591.

    how can i solve this? can i change the collation during an export ? I can't change the collation of table because it is related to other tables and it may produce some problems.

    thanks in advance for your help.

    Have you tried the standard Derived Column transformation?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply