Why SSIS over DTS? · Running DTS in SQL 05 (using SSIS) only provides a “wrapper” to the DTS package.The package will not take advantage of the performance gains that SSIS has to offer.· Clients that are using DTS to move data into a data warehouse will inevitably experience
larger and larger volumes of data to move, clean, and transform. The load time for these
processes will increase to a point that will become unacceptable. For example, clients that
experience load times of 6, 8, or 10+ hours are already squeezed for time and cannot afford
to see these times increase further. Using SSIS will cut this time by a fraction of the original
load time thus allowing for more processes to take place that may have originally been put
on alternate schedules due to resource contention of the original DTS process.
· Clients that are using DTS to move, clean, and transform data to non-data warehouse data
structures will experience the same problems as the warehouse loads. SSIS today provides
more robust and maintainable options for on-going development of ETL loads. The techniques
for developing packages in SSIS are more standard and straight-forward compared to the
alternate techniques required to perform those same actions in DTS. SSIS=standard techniques,
DTS=hack techniques.
· Both Data warehouse and non-data warehouse ETL loads using DTS will also have higher
maintenance costs due to the lack of functionality now present in SSIS. The lack of
functionality in DTS will hamstring developers into using more complicated (hack) techniques
to apply business rules for the ETL processes. As these techniques become more complicated,
they require more maintenance time and are also more error-prone due to the very nature of
implementing current and on-going business requirements in DTS. As developers switch roles
or change positions, the replacements for those developers will be on a steep learning curve
in regards to the complexity of the DTS packages that have evolved/devolved over time.
Convert your DTS packages instantly with DTSxChange NOW!
WWW.DTSxChange.com
How Big Is Your Package?