Post reply

SSIS Error Stating found string too large for buffer

  • July 21, 2009 at 6:58 am

    #136375

    I am getting the following Error when trying to import data from a raw file into a database table. Is there anything in this that tells me where to find the column casing the error. Any help in resolving this is appreciated.

    [Raw File Source [1562]] Error: String too long. The adapter read a string that was 3223552 bytes long, and expected a string no longer than 3 bytes,

    at offset 3349. This could indicate a damaged input file. The file shows a string length that is too large for the buffer column.

  • July 21, 2009 at 12:43 pm

    #1027854

    I figured it out. Apparently you can create a raw file by selecting the top 0 * from a table if there is a timestamp datatype column in the table. Once I removed that column when creating my raw file (which I was using as a template to ensure only the correct data would be matched on a union all task) I was able to import with no problem. In short SSIS 2008 has trouble with timestamp datatypes.

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

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