SSIS - SQL Server Integration Services for performing ETL package.
What is mean by ETL?
Extract Transform and Load any Data.
EXTRACT (From Source)=> TRANSFORM(Convert/Calculate/Pivot/loop)=>LOAD(To Destination)
ETL package main usage for Data-ware housing.
Development Environment:
SQL Server Integration Service Project in Business Intelligence Development Studio(BIDS).
Set Up Details in Step by Step manner
http://www.mssqltips.com/sqlservertip/1807/sql-server-2008-client-tools-installation
SSIS package move data in the below content
- ADO.NET DATA SOURCES & DESTINATION
- FLAT FILE DATA SOURCES & DESTINATION
- RAW FILE DATA SOURCES & DESTINATION
- OLE DB DATA SOURCES & DESTINATION
- MICROSOFT ACCESS SOURCES & DESTINATION
CONNECTION MANAGER:
Used to create connection content for the above source and Destination
Tabs available in the Development Environment
Control Flow
Data Flow
Event Handler
Package Explorer
Execution Process
 |
In the upcoming days we intended to post some sample packages (SSIS Tutorail).
|
No comments :
Post a Comment