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 |
|
maryxu
Starting Member
36 Posts |
 Posted - 2008-04-29 : 12:09:23
|
| Hi, we are using sql 2000, i would like to know is there a way to transfer multiple tables data (export and import) from one server to another server by using one DTS? thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-29 : 13:19:32
|
| yup you can transfer data from multiple tables using DTS Export Import wizard. The wizard lets you to select what all tables you need to transfer data and also enables you to define how you want to define transformations.http://www.verio.com/support/documents/view_article.cfm?doc_id=3846 |
 |
|
|
|
|
|
transfer multiple tables data