What is the difference between DTS and SSIS?
- 3 Answers
- 36361 Views
- Allianz, I also Faced
- E-Mail Answers
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 function of master database?
What is the purpose of sql profiler in sql server?
Distinguish between nested subquery and correlated subquery?
What is change data capture (cdc) in sql server 2008?
What is store procedure? How do they work? When do you use?
How each E-R model constructs can be mapped to the relational model?
What is a self join in sql server?
Is it possible to update the views? If yes, how, if not, why?
What are the differences between decimal and float in ms sql server?
How do you know if sql server is running on your local system?
What is an example of a foreign key?
What are drilldown reports?
How to delete duplicate rows in sql server?
Explain what is dbcc?
What is the difference between writing data to mirrored drives versus raid5 drives
