Post reply

too large for the specified buffer size

  • October 18, 2002 at 4:44 am

    #105288

    Data for source column 9 ('Col009') is too large for the specified buffer size.

    This is the error I get when executing my package. I'm trying to import a text-file with a field that can contain up to 5000 characters. Can you give me the solution to my problem please?

    Thx a lot!

  • October 18, 2002 at 5:31 am

    #438871

    Check the column width that DTS in generating for the column on the destination tab. DTS only reference the first few records or so and may not realize the actual length or it arbitrarily chose 255 (default). Make sure it is making wide enough for the data coming in.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • October 18, 2002 at 5:48 am

    #438873

    Place the large columns as the first columns in your select stmts, i beleive there is a known bug relating to this

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

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