none
More than One code Page

    Question

  • Hi,

    when i import data from Flat file to Oledb i am getting the following Error.

    The column "xxxxxxx" cannot be processed because more than one code page (65001 and 1252) are specified for it.

    I have changed the Defaultcodepage to True but getting Same.kindly help me to resolve this issue.

    Thanks.


    • Edited by aravindhrm Wednesday, April 10, 2013 2:21 PM
    Wednesday, April 10, 2013 2:18 PM

Answers

  • Check out the length of your column in the output column page. Set it to the proper value so the column does not get truncated.
    • Marked as answer by Eileen Zhao Tuesday, April 16, 2013 7:07 AM
    Wednesday, April 10, 2013 3:48 PM

All replies

  • Are you using SSIS 2005? 

    SOmetimes this can happen when you change properties of your source. The metadata will not update properly and does not reflect the codepage you selected in the GUI.

    Try to remove the connection and recreate it with the correct codepage. This should refresh the metadata of the SSIS package.

    Wednesday, April 10, 2013 2:32 PM
  • hi Michael,

    I am using the SSIS 2008.i have removed and created couple of time but still i am facing the same issue.

    Wednesday, April 10, 2013 3:01 PM
  • Set the property AlwaysUseDefaultCodePage of your oledb destination to TRUE

    Arthur My Blog



    Wednesday, April 10, 2013 3:08 PM
    Moderator
  • I think ArthurZ's solution should work
    Wednesday, April 10, 2013 3:38 PM
  • hi,

    After changing the defaultcodepage to 65001 the i am getting the following error

    [Flat File Source [1]] Error: The "output column "XXXx "(14)" failed because 

    truncation occurred, and the truncation row disposition on "output column 
    XXXx "(14)" specifies failure on truncation. A truncation error occurred on
     the specified object of the specified component.

    pls do the needful

    Wednesday, April 10, 2013 3:44 PM
  • Check out the length of your column in the output column page. Set it to the proper value so the column does not get truncated.
    • Marked as answer by Eileen Zhao Tuesday, April 16, 2013 7:07 AM
    Wednesday, April 10, 2013 3:48 PM
  • Arthur, where is this found in VS2008?  I experience the same issue in VS2008 against SQL2008R2.

    -Al H


    • Edited by AlHowarthWF Wednesday, December 11, 2013 5:33 PM add
    Wednesday, December 11, 2013 5:33 PM
  • Al, this property:

    ??


    Arthur My Blog

    Wednesday, December 11, 2013 6:33 PM
    Moderator