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

 

About sqlschool

SQL School (Regd: SequelGate Innovative Technologies Pvt. Ltd.) is one of fastest growing organization delivering Realtime Training and Realtime Projects exclusively on Microsoft SQL Server. Our Training services include SQL DBA Online Training, MSBI Online Training, SQL DBA Classroom Training, MSBI Classroom Training and Realtime Projects. SQL School, established in February, 2008 is now, one of the best institute offering Trainings on SQL Server, SQL Database Administration (DBA) and Business Intelligence (BI) technologies. We have been working with numerous consultancies in India, US, UK and Australia. We undertake Online Trainings and Corporate Trainings on SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012 (DENALI) versions. We make sure that all our sessions are very much interactive and well structured. We encourage every participant to come up with his / her own queries during & after the training sessions. We prefer practical approach rather than theoretical information to master the technical depth of the technology. We provide excellent Lab Handouts for practice, Realtime Case Studies and Projects on SQL Server Administration (SQL DBA) and Microsoft Business Intelligence (MS BI) Training courses. Free LIVE DEMOs would be provided prior to training registration. Specific DAY to DAY Course Plan will also be shared prior to training registration to ensure transparency of our Training services.