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

Related questions

0 votes
asked Jun 13, 2023 in Sql by rahuljain1
0 votes
asked Sep 23, 2021 in Azure Data Factory by Robin
0 votes
asked Apr 26, 2023 in Looker by Robin
...