Data Link support for Data Transformation Services

[jlegue]

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

[russell]

dts is the right way to import disparate data sources. dont use data link. use the connection objects in the dts designer. try not to use dts wizard, use the dts editor instead. oracle client tools need to be installed on mssql to import from oracle data source