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...