What is the difference between DTS and SSIS?

Answers were Sorted based on User's Feedback



What is the difference between DTS and SSIS?..

Answer / ramesh

DTS--> Data Transformation Services
SSIS-->Sql Server Integration Services
in DTS:Message Boxes in activeX scripts
SSIS :Message Boxes In Script Tasks

In DTS:dynamic Properties+ActiveX scripts
SSIS :Configurations+PropertyExpressions

IN
DTS:no deploymentWizard
SSIS:deployment wizards are there

DTs:Limited Set of Transformations
SSIS:huge number of Transformations are available
DTS:ni BI Functionality
SSIS:complete BI Functionality

Is This Answer Correct ?    48 Yes 11 No

What is the difference between DTS and SSIS?..

Answer / rajesh s. chandan

Internal architect of SSIS is entirely different than DTS
and mainly designed to achieve high degree of parallelism
and to improve performance. In Microsoft Business
Intelligence, Integration services are coupled with
Analysis and reporting services. It could process thet data
for Dimension processing and Partition processing.Using
Data profiling task you could analyze data before
processing and find out the percentage of null values.
Using WMI Data reader task you could get information about
system hardware, software and also network information.
More important, it has great security features like
password protection, Digital signature, Encrypt with
password. Even we could secure it using Operating system
permission and using SQL server roles.

SSIS is really a great!

Is This Answer Correct ?    25 Yes 2 No

What is the difference between DTS and SSIS?..

Answer / maddy

Hi,
The DTS and SSIS are both used in SQL Server
Transformations. Th e DTS was used for transformation
purpose upto SQL Server 2000 and SSIS (Including SSAS and
SSRS) are the advanced to DTS and are included in SQL Server
2005 onwards. The capability of SSIS tool in comparison with
DTS is tremendous. This SSIS tool is in competition with
other ETL Tools in the present.The SSIS has lot added
features as per the current requirements.

Is This Answer Correct ?    22 Yes 12 No

Post New Answer

More SQL Server Interview Questions

What is difference between delete & truncate commands?

0 Answers  


What is the difference between DTS and SSIS?

3 Answers   Allianz,


Can a synonym name of a table be used instead of a table name in a select statement?

0 Answers  


Define full outer join in sql server joins?

0 Answers  


what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,






Explain the truncate command? : SQL Server Architecture

0 Answers  


What is an indexing technique?

0 Answers  


What is the architecture of ms sql reporting service?

0 Answers  


How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  


Does view occupy space?

0 Answers  


Explain rdbms?

0 Answers  


What are the underflow and overflow behaviors on float literals?

0 Answers  


Categories