Home Forums Data Warehousing Integration Services SSIS on SQL Server 2008R2 "The value is too large to fit in the column data area of the buffer." RE: SSIS on SQL Server 2008R2 "The value is too large to fit in the column data area of the buffer."

  • I like Koens suggestion.

    I have seen that error due to receiving too many columns for the defined script component or for receiving data too large for the output defined in the script component.

    One other possible contender is if there is a derived column transformation after the script component. I just had one blow up with errors in the script component but the real problem was in the derived column metadata.

    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