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