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
|
Sunday, 7 July 2013
Differences B/W DTS and SSIS
Labels:
Differences,
MSBI
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment