Post reply

Data for Source Column istoo Large for the specified Buffer Size- DTS

  • July 2, 2008 at 6:11 pm

    #184189

    Hi

    I'm transferring data from a Excel Spreadsheet to SQL Server 2000 using DTS and my transformation gives me the error

    Data for Source Column 110 (Description) is too Large for the specified Buffer Size.

    My source data is 500 characters long, I've looked up for solutions and have made changes to the Jet registry as mentioned in the MSDN forum but of no avail. Any suggestions????

  • July 3, 2008 at 2:15 am

    #837651

    Have you tried using BCP? Perhaps you should first export the excel sheet to .txt and then import the .txt with BCP.

  • July 3, 2008 at 11:24 am

    #838024

    Yes, the solutions by AART is the way to go..

    Maninder
    www.dbanation.com

  • July 3, 2008 at 12:50 pm

    #838083

    My source is a tab delimited text file, which i viewed in Excel

  • July 4, 2008 at 7:29 am

    #838356

    Well then you can use your tab delimited file to import the data by using BCP.

  • July 7, 2008 at 1:41 pm

    #839145

    [font="Arial"]Hello,

    In DTS when you are sending data it defaults any varchar field to 8000 in length. Why? Who in the world knows what Microsoft was thinking. However, check the definition of your field lengths because if you leave them at 8000 then the server thinks you are exceeding the maximum length of a record.

    That's probably all you need to do. Define the varchar's to a ballpark amount like 80 if you don't know the exact length. Just don't leave them at 8000.

    Regards,

    Terry

    [/font]

Viewing 6 posts - 1 through 5 (of 5 total)

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