0 votes
in Looker by
What are the noticeable differences you can find upon comparing DTS and SSIS?

1 Answer

0 votes
by
DTS stands for Data transformation services, while SSIS stands for SQL Server Integration Services.

SSIS can handle a lot of errors irrespective of their complexity, size, and source. On the other side, the error handling capacity of DTS is limited.

There is actually not Business Intelligence functionality in the DTS, while SSIS allows full Business Intelligence Integration.

SSIS comes with an excellent development wizard. The same is absent in the case of DTS.

When it comes to transformation, DTS cannot compete for SSIS

SSIS support .Net scripting while the DTS support X scripting
...