I only input a value for the data source.  This is TNSNames.ora entry that I use with the Oracle Client to connect to the Oracle database.  Even if you use...

Agreed.   It will be anything but fast, but for folks who have not used Oracle, at least you can still use TSQL Syntax.  The only real difference is that you...

Well, technically, the answer is yes, but this is highly a matter of what you are trying to accomplish.  Remember that DTS is primarily an ETL tool.  If you are looking...