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)
 data migration

Author  Topic 

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-05-01 : 20:02:46
Hi friends
am exporting vvisual foxpro data to sql server and am using DTS to export it.
my question is is there any option to export all tables at once rather than doing one at a time?
Thanks


Cheers

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2005-05-01 : 23:44:41
You can setup your DTS package so that all of the export tasks run in parallel.

CODO ERGO SUM
Go to Top of Page

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-05-02 : 00:00:10
Thanks Michael
finally i resolved it using import data option which allowed import multiple tables.


Cheers
Go to Top of Page
   

- Advertisement -