Home Forums Data Warehousing Integration Services The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for it. RE: The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for it.

  • August 22, 2009 at 4:58 am

    #1043254

    madhukeshwark (8/22/2009)

    Hi Winston Smith !

    As per my understanding, u have set the flat file connection manager configuration setting correctly. You need to specify the delimiter in the connection manager.

    Pls let me know which tasks u r using to achieve this task?

    Hi.

    I think you misread my post. I didnt change anything for the flatfile connection as the flag was not present. what i changed was:

    1. I have set the "alwaysUseDefaultCodePage" property of the destination OLEDB connection to True.

    2. I have set the codepage property of the OLEDB connection to 65001

    This allowed the package to work but I would really like to understand what a code page is, why this error presents its self so often, if its a bug and if not, what usefullness does it provide.

    Regarding what im using, i simply have a flat file connection feeding to a OLEDB destination connection