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 |
rajani
Constraint Violating Yak Guru
367 Posts |
Posted - 2005-05-01 : 20:02:46
|
Hi friendsam 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?ThanksCheers |
|
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 |
 |
|
rajani
Constraint Violating Yak Guru
367 Posts |
Posted - 2005-05-02 : 00:00:10
|
Thanks Michaelfinally i resolved it using import data option which allowed import multiple tables.Cheers |
 |
|
|
|
|