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