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 |
|
vinoth86
Starting Member
27 Posts |
 Posted - 2008-04-24 : 05:03:40
|
| Can any one say,what is DTS Package?DTS Export/Import wizard --What it does??Help me! |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-04-24 : 05:05:33
|
| DTS is used in SQL 2000 for transfering data from one to another. you can read up about it on Books OnlineEm |
 |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-24 : 05:10:31
|
| DTS export import wizard is used for exporting & importing of data between heterogenous sources (db to db,flat file to db,...). You can find this in your Enterprise manager. Select you server in enterprise manager and click tools->Data Transformation services->ExportData/ImportData and you can launch export import wizard. You can configure source 7 destination connection and specify object to object export/import or via a SQL query. More details here:-http://articles.techrepublic.com.com/5100-1035_11-1043668.html |
|
|
|
|
|
|
What is DTS Export/Import wizard in SQL Server?