What is the difference between DTS and SSIS?
Answer Posted / 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 View All Answers
what is create database syntax? : Sql server database administration
What are the types of subquery?
what are database files and filegroups? : Sql server database administration
Define cursor locking
What do you do in data exploration
What is sparse columns of sql server 2008?
What does man by sql wildcard characters in sql server?
Explain the disadvantages of cursors?
How to get the definition of a user defined function back?
What are the different SQL Server Versions you have worked on?
How can you tell if a database object is invalid?
What are the three different part of rdl file explain them?
Why use update_statistics command in sql server?
What is the difference between push and pull subscription? : sql server replication
Name 3 ways to get an accurate count of the number of records in a table?