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 difference between rownum and rowid?
how can you check the level of fragmentation on a table? : Sql server administration
application server is slow what may be the problem
Explain what is use of dbcc commands?
What is faster join or union?
How do I open port 1433?
What happens if date-only values are provided as date and time literals?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What does select 1 mean?
What are some examples of schemas?
How to find the login name linked to a given user name?
What are the dmvs?
Explain different types of locks in sql server.
Tell me what is a linked server?
What is inner join in sql server joins?