"Truncation may occur due to inserting data from data flow column...." in SSIS 2008

  • ravi@sql

    SSCrazy

    Points: 2121

    HI All,

    Am getting that error in SSIS 2008 even i changed the column length in flat file source in advanced editor..i guess its not saved so that it is giving the same error again.

    So colud any body tell me how that meta data property is to be refreshed or solve this issue ?

    Regards,

    Ravindra

  • SQLRNNR

    SSC Guru

    Points: 281210

    Oftentimes you need to place a derived column transformation to force the conversion.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • ravi@sql

    SSCrazy

    Points: 2121

    I have done that column propertied like name,size , data type every thing is perfect. still am getting this error.

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

    please help to fix this asap.

    Regrads,

    Ravi

  • david.alcock

    SSCertifiable

    Points: 6021

    Check the advanced editor on the data source properties for input and output columns...these are often defined by a sample of data and could well be wrong, check each one, one of them is bound to smaller than expected.

    'Only he who wanders finds new paths'

  • joefan@joe-fan.com

    Newbie

    Points: 1

    If all else fails try this.

    What I've experienced is that this error shows up occasionally after I've copied and pasted existing Ole DB Destination/Source element either from the same Data Flow Task or a Data Flow Task from another package and then start changing the details within.

    Even when the Data Type and Length of the columns are identical, this warning still appears on occasion. This is when I delete the copied element(s) and build them from scratch. This has made the warning disappear.

    My guess is that the metadata is fouled up during the copy/paste.

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

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