Diffrence between DTS vs SSIS

Answer Posted / shyamsri83

DTS-Data Trasformation Services available up to SQL Server
2000
SSIS - Sql server integration services. available from sql
server 2005. SSIS is introduced instead of DTS

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

533


How to rebuild indexes with alter index ... Rebuild?

584


What are different types of statement?

522


What is report snapshot in ssrs?

163


What is subreport?

96






What is the difference between system objects and user objects?

701


What are the differences between local and global temporary tables?

548


What stored procedure would you use to view lock information?

520


Explain temporary table vs table variable by using cursor alternative?

517


plss anybody specify tha constrian management system in dbms

1568


What command do we use to rename a database?

609


Explain subquery and state its properties?

545


What are the filtered indexes?

594


How to modify an existing user defined function?

589


What do you mean by 'normalization'?

602