S.no
|
DTS
|
SSIS
|
1
|
Data Transformation
Services
|
Sql Server Integration
Services
|
2
|
Using Activex Script
|
Using Scripting
Language
|
3
|
No Deployment wizard
|
Deployment wizard
|
4
|
Limited Set of
Transformation available
|
Huge of Transformations
available
|
5
|
Not Supporting BI
Functionality
|
Completely supporting
end to end process of BI
|
6
|
Single Tasks at a time
|
Multi Tasks run
parallel
|
7
|
It is Un managed script
|
Managed by CLR
|
8
|
DTS can develop thru
Enterprise manage
|
SSIS can thru Business
Intelligence Development Studio (BIDS, nothing but new version of VS IDE)
|
9
|
We can deploy only at
local server
|
It can be deployed
using multiple server using BIDS
|
10
|
Designer contains
Single Pane
|
SSIS designer contains
4 design panes:
|
a) Control Flow
|
||
b) Data Flow
|
||
c) Event Handlers &
|
||
d) Package Explorer.
|
||
11
|
No Event Hander
|
Event Handler Available
|
12
|
No Solution Explorer
|
Solution Explorer is
available, with packages, connections and Data Source Views (DSV)
|
13
|
Connection and other
values are static, not controlled at runtime.
|
It can be controlled
dynamically using configuration
|
Q: What is SSRS? Ø SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø It is used for preparing and delivering interactive and variety of reports. Ø It is administered through an web based interface. Ø Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...
Good Article for Beginner. Please share more info!
ReplyDeleteAlso please try to share few complex transformations.
ReplyDeletethanks for your suggestion
Deletevery useful blog for learners..slides helped me in understanding various transformations..
ReplyDeleteThanks for your feedback
Delete