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 |
|
jayl
Starting Member
4 Posts |
 Posted - 2006-12-21 : 10:06:59
|
| Hi All,I am looking to use DTS to manipulate data from a number of sources (access, oracle, etc.) and am looking for some direction as to best practices and gotchas that I should worry about. Do people recommend using DTS or is there a better way of doing this type of data import/manipulation? What would I use Data Link for when using DTS?Thanks in advance,---Jay |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-22 : 06:14:50
|
| For all data sources reachable with OLEDB, I use Linked Server instead of DTS.I beleive I have greater control this way. DTS has been a disappointment for me, and the new SSIS (in my opinion) is not much better.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
Data Link support for Data Transformation Services