Post reply

DTS - Fetch Buffer Size doesnt work sometimes!!

  • October 2, 2006 at 11:10 pm

    #76593

    In a DTS packages we have number of tasks.

    In Task Properties,options there is a fetch buffer size option.

    fetch buffer size's default is 1.

    We had set it to 3000 so assuming that it fetches 3000 rows at a time

    from SS2k.

    But the problem is in some machines DTS fetches around 2800 rows out of 50000 rows once and the task gets completed.

    Is there any setting that needs to be done?.

    Please let me know if any of you know solution to this.

    Finally we had to set the fetch buffer size's value to 1.

    regards,

    chethan

  • October 3, 2006 at 9:41 am

    #663869

    Depending on your environment (amount of memory, size of data row), you may be overflowing the buffer by setting Fetch Buffer Size to 3000.  I know that any setting greater than 1 is ignored if the data contains any BLOB storage data.  There aren't any hard rules for how to adjust this setting and I usually leave it at 1. 

    You may have some luck adjusting the Fetch Buffer Size in conjunction with Insert Batch Size, which specifies the number of rows inserted between each commit.

    Greg

    Greg

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

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