DTS fetch buffer size | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS fetch buffer size

Hi, I have a DTS data transfer task. In the option tab I see the fetch buffer size as 9999. BOL says that it is the number of rows to fetch from Source. I have to fetch around 45M of records which will take around 75 minutes.
Is it true that we cannot fetch more than 9999 rows, if I have very good
Server configuration? Any other ways? Thanks for your help
http://www.sql-server-performance.com/dts.asp fyi. It depends on the memory available and processor defined on the SQL server, the default is 0, which means a single batch so if you have 10 million rows they will not be committed until the end. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks Satya. What you said is true wrt to batch size. I am discussing about the ‘fetch buffer size’ option and not ‘batch size’ option It BOL says that, it refers to the number of rows to be fetched at source.
I am not able to increase it to more than 9999.
]]>