ETL Training

Why to use SSIS?

PURPOSE OF SSIS:
E 1. TO PERFORM DATA EXTRACTION OPERATION FROM HETEROGENOUS (DIFFERENT FORMAT) SOURCES
EX: GATHER DATA FROM SQL DATABASE + EXCEL SHEET + TXT FILE

T 2. TO PERFORM DATA TRANSFORMATION OPERATIONS
EX: DUPLICATE DATA TO MULTIPLE SERVERS, COMPARE & MERGE

L 3. TO LOAD DATA ONTO ANY DESTINATIONS, OF ANY FORMAT.
EXTRACTION OF DATA(E), TRANSFORMATION (T), DATA LOADS (L)

4. TO DESIGN “DATAWAREHOUSE” (DWH). ALSO FOR DATA LOAD OPERATIONS @ ETL TECHNIQUES

DATAWAREHOUSE IS A DATABASE USED TO STORE HISTORICAL, BUSINESS LEVEL INACTIVE
INFORMATION. SSIS CAN BE USED TO COMPARE THE LIVE (REAL-TIME) DATA WITH EXISTING
WAREHOUSE DATA AND IDENTIFY NEW ROWS / UPDATES TO EXISTING ROWS.

5. TO PERFORM WINDOWS ADMIN ACTIVITES EX: IIS, WMI

6. TO PERFORM SQL DATABASE ADMIN ACTIVITES EX: DATABASE MIGRATIONS

7. TO PERFORM ANY TYPE OF SQL OPERATIONS (T-SQL, PL/SQL, EXCEL SQL…)

SSIS School of Training