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."

  • gbritton1 (7/29/2014)


    Koen Verbeeck (7/29/2014)


    Instead of the console line, try a message box perhaps?

    Does everything work if you get rid of the script component?

    I added calls to MessageBox before each statement in the script source. This finally exposed the problem:

    I had been focused on the Data column, since that is what was increased. However, the sample data included the ErrorMessage column as well (See the source from the previous post). This column (not the data column) has now exceeded the specifications.

    Koen, zonder uw hulp had ik deze fout helemaal gemissed!

    Hartelijk bedankt!!

    Glad you found the issue 😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP