SSIS |
DTS |
SSIS stands for SQL Server Integration Services. |
DTS stands for Data Transformation Services. |
It has powerful and complex error handling support. |
It has limited error handling support. |
It contains message boxes in .NET scripts. |
It contains message boxes in ActiveX scripting. |
It consists of an interactive deployment wizard. |
It does not have any deployment wizard. |
It has a wide range for the number of transformations. |
It has a limited number of transformations. |
It is suitable for complete BI (Business Intelligence) integration. |
It does not support any BI functionality. |