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 |
|
marat
Yak Posting Veteran
85 Posts |
 Posted - 2004-02-08 : 18:29:50
|
| Is there any differences between Import and Export in DTS.I think I can use Import wizard to Export data and vs Export wizard to Import data, because source and destination are exchangible.Am I right? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-08 : 19:15:37
|
| There are no separate Import and Export wizards, they are both the same program. |
 |
|
|
marat
Yak Posting Veteran
85 Posts |
Posted - 2004-02-08 : 21:08:33
|
| Ok,If I go to SQL Enterprise Manager, under Tools, Data Transformation Services,I have two options: Import Data and Export Data.What is the principal difference?Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-02-08 : 22:25:48
|
| The name of the options, that's it. Same program, same function. As you said, you could switch source and destination and get the same result. |
|
|
|
marat
Yak Posting Veteran
85 Posts |
Posted - 2004-02-09 : 01:32:12
|
| Cheers |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-09 : 05:09:48
|
| All it does is default one of the connections to whatever you have selected at the time.You can look at what is generated and you will see it is just 2 connections which you could create without the wizard.Try doing things without the wizard and you will learn a lot more about what is available and how it is implemented.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
DTS Import vs Export