Post reply

DTS Buffer Error

  • May 27, 2004 at 11:59 am

    #59711

    I'm trying to import an Excel spreadsheet using the DTS wizard and most of the tables import fine. One table has data that apparently exceeds the specified buffer size. I changed the length field within the table, but that hasn't helped the situation. Can somebody direct me to changing the buffer size to allow this data to be imported successfully?
     
    Thanks,
     
    Alan

     

  • May 28, 2004 at 1:08 am

    #508117

    Probably one of the rows in the excel sheet exceeds the maximum buffer size. To over come this problem shift all such rows at the top of the excel sheet and try running the DTS import. This should solve the problem.

    Refer to microsoft msdn site for detailed explanation.

    Rgds,

    Amol

  • May 28, 2004 at 4:26 am

    #508151

    I'll try this when I get back to work today. Hope it works.

    Thanks,

    Alan

  • May 28, 2004 at 6:06 am

    #508170

    I shifted the rows over as you mentioned and the same error occured.

    Thanks,

    Alan

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

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