Post reply

Data Loading error

  • May 13, 2009 at 4:36 pm

    #130861

    Hi

    I created a dtsx package for bulkload, it is a huge data more than a million records in the text file. After loading 200000

    there showing following error:

    Data conversion failed. The data conversion for column " EMAIL_ADDR_TX " returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.

    Can any one help me to resolve this issue....

    Thanks,

    calibar

  • May 13, 2009 at 10:02 pm

    #994257

    calibar2k (5/13/2009)

    Hi

    I created a dtsx package for bulkload, it is a huge data more than a million records in the text file. After loading 200000

    there showing following error:

    Data conversion failed. The data conversion for column " EMAIL_ADDR_TX " returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.

    Can any one help me to resolve this issue....

    Thanks,

    calibar

    Whats the definition for EMAIL_ADDR_TX and what's in the corresponding filed on the line that fails?

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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