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)
 Why is it slow(Terribly) when the data is getting transferred from SQL to Access using the DTS?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-07-21 : 07:19:01
KARTHIK writes "The data transfer is very very slow across the network(Say the SQL is in one server) and the access database is put in another system using the package built with the help of DTS!! Could U please suggest the right path of go about with this!!!!I will B very much tnkful!!"

X002548
Not Just a Number

15586 Posts

Posted - 2003-07-21 : 09:52:46
quote:

The data transfer is very very slow across the network



Usually

quote:

(Say the SQL is in one server) and the access database is put in another system



Que?

quote:

using the package built with the help of DTS!!



Use bcp and winzip

quote:

Could U please suggest the right path of go about with this!!!!I will B very much tnkful!!"



Link Access to SQL Server?

Don't use Access?

Don't move data around unless you have to?



Brett

8-)
Go to Top of Page
   

- Advertisement -