Post reply

FLAT FILE SOURCE

  • January 19, 2011 at 12:38 pm

    #230514

    [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Column 2" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

    [Flat File Source [1]] Error: The "output column "Column 2" (164)" failed because truncation occurred, and the truncation row disposition on "output column "Column 2" (164)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

    I AM TRYING TO LOAD THE DATA FROM FLAT FILE SOURCE TO THE TABLE. I AM FACING THE ABOUVE ERRORS.

    CAN ANY ONE SUGGEST ME THE IDEA TO RESOLVE THESE ERRORS.

    thanks.

  • January 19, 2011 at 1:12 pm

    #1275537

    The error suggests that the defined size of "Column 2" is not big enough to hold the data you are trying to load. You need to either edit the Flat File Source, go to the "Columns" tab and expand the size of the column in the column properties or change the error configuration for the Flat File Source to ignore truncation (in which case your data will be truncated before it flows to the destination).

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

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