Home Forums Data Warehousing Integration Services ANSWERED - Flat file problem - input column is 1252 and is required to be 65001 RE: ANSWERED - Flat file problem - input column is 1252 and is required to be 65001

  • FYI

    I had a simple extract package ... working fine.

    I went in and added a column to the extract proc, added the column to the destination file.

    Opened this SSIS package refreshed the meta data and mapped the new column in the data flow task from proc to file.

    Then when running in debug I got this exact code page error on an EXISTING column that had not changed position nor data type.

    The solution was to change the code page of the destination file connection to the invalid suggestion in the error msg (65001) run it so it fails again then switch the code page back to the original correct setting 1252 and run again.

    happy happy.