sql server dts: 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

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200612/1

Things that you should be very aware of are

Datatype comparisons (What in the source system is the same datatype as
the destination)
Datatype ranges (Dates are good here)
Drivers (ODBC, OLEDB)
Scheduling (Where the package gets executed)


These are a small sample of the issues you may encounter.

We have a large amount of articles on www.SQLDTS.com that may help you.
Come back when you have got your project under way with more specific
questions as well.



--


Regards



Allan Mitchell


Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com


[quoted text, click to view]