satishthota (8/17/2009)
What is the difference between DTS and SSIS 2005?
give more differences between them?
DTS is a depracated technology in SQL 2005/2008, I wouldn't expect them to continue to support it too much longer..
SSIS has a much more logical seperation between control flow and data movement.
Shared connection definitions at the project level.
Lots of control flow and data flow components to choose from.
Error pipelines in the data flow where you can shunt records that fail in a particular component..
How about looking at this link:
http://decipherinfosys.wordpress.com/2008/03/11/dts-vs-ssis-a-basic-overview/
CEWII