• coool_sweet (4/16/2015)


    hi

    i am adding new field to my existing package which is char(10).

    getting this error:

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

    i right click flat file destination->i only see external and input column over there,

    there is no output column.

    in flat file connection mamanger ->outputcolumn->its char(10)

    what needs to be change here?

    Quick question, why adding CHAR(10) / 0x0A / Line feed to the output?

    😎