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.

  • April 2, 2013 at 1:01 pm

    #1602941

    In your dataflow right click your OLE DB Destination and click properties.

    In your Properties pane which might be on the right side.

    Under Custom Properties there is an option called AlwaysUseDefaultCode to True.

    Manually change your DefaultCodePage to the code that it says it can't convert. So in my scenario it said it couldn't do pages 65001 to 1295. I changed the DefaultCodePage 65001. From there your Destination will have a "Warning" on it but you should be able to execute the package now.