Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-02-15 : 11:41:54
|
Hi why its it that my transformation is very slow for one of my tables in access like for about 250,000 rows of data it takes about 2 hours fot the data to be transfered from SQL to access. Is any way i can speed this up ?. Thanks |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2007-02-20 : 09:14:16
|
Just to give a update on this, when into the DTS and select the transform link and select the option tab and changed the insert batch size to 1000 this helped speed up the transfer |
|
|
|
|
|