Sunday, 7 July 2013

Differences B/W DTS and SSIS

DTS
SSIS
1.DTS is available in 2000
1. SSIS is available from 2005 onwards
2 DTS designed for DTS(Data Transform Sources)
2 SSIS designed for ETL
3 DTS has Single pane for all operations
3 SSIS is having multiple panes/Screens for multiple operations
4 Data Transformations available
4 Data Transformations are embedded in Data Flow Task
5 No Conn_Mgr,
   No Event_Handling
   No Looping through files & Foleder
5 Conn_Mgr, Event_Handling, Looping_Through Files & Folders are available
6 Message Boxes displayed in “ActiveX Script Task”
6 Message Boxes displayed in Script Task
7 DTS has Less Transformations
7 SSIS has More Transformations
8 DTS is Partial BI
8 SSIS is Full Support to BI
9 No Deployment Wizard
9 Deployment Wizard is there
10 Saved in
        SQL Server
        File System
10 Saved in Local File System & Deployed in SQL Server

No comments:

Post a Comment