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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Transfer from SQL To Access

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
Go to Top of Page
   

- Advertisement -