DTS stands for Data transformation services while the SSIS stands for SQL Server Integration services.SSIS can handle a lot of errors irrespective of their COMPLEXITY, size and source. In the other side the error handling capacity of DTS is limitedThere is actually not Business Intelligence FUNCTIONALITY in the DTS while SSIS ALLOW FULLY Business Intelligence IntegrationSSIS comes with an excellent development wizard. The same is absent in CASE of DTSWhen it comes to transformation, DTS cannot compete SSIS SSIS support .Net scripting while the DTS support X scripting

DTS stands for Data transformation services while the SSIS stands for SQL Server Integration services.SSIS can handle a lot of errors irrespective of their complexity, size and source. In the other side the error handling capacity of DTS is limitedThere is actually not Business Intelligence functionality in the DTS while SSIS allow fully Business Intelligence IntegrationSSIS comes with an excellent development wizard. The same is absent in case of DTSWhen it comes to transformation, DTS cannot compete SSIS SSIS support .Net scripting while the DTS support X scripting