SSIS Training

SSIS Classroom Training (Integration Services with ETL & DW)

SSIS provides Data Extraction, Consolidation and Loading Options (ETL), SQL Server Coding enhancements, Data Warehousing and Customizations for SQL Server Developers, Administrators, BI Engineers and Data Analysts. In our SSIS Trainings, we deal with complete SSIS Design and Development including SCD, Profiling, Tuning and Fact Loads. All sessions are completely practical and realtime.

Prerequisites: Participant should have knowledge on SQL Server T-SQL Queries & Tuning to join this Real-time Practical SSIS Training Course.

Schedules for MSBI - SSIS Classroom Training

Schedules Timings Free Demo
Schedule 1: 8 AM to 9:30 AM Register Today
Schedule 2: 8 PM to 9:30 PM Register Today

This MSBI SSIS Classroom Training includes ONE Real-time Project.
Trainer Profile, Duration, Pricing
Trainer: Mr Sai Phanindra T (11+ Yrs Exp, MS FTE)
Duration: 2.5 Weeks (Mon - Fri/Sat)

Total Course Fee: INR 5500/-
Training Location & Lab:
SR Nagar - Ameerpet, Hyderabad (India). Map
Course includes Real-time Project, Placement, Support.

If none of the above LIVE SSIS Classroom Training schedules work for you? please opt for On-demand, 24x7 SSIS Training Videos

Module I: Basic SSIS Development
Module II: Advanced SSIS Development
Module III: SSIS Deployment and Security

Introduction to SSIS & Data Warehouse

  • Need for SSIS and ETL / DWH Entities
  • Data Warehouse Design and SSIS
  • DW Components and SSIS Tools
  • SSIS Configuration and Catalog DB
  • Control Flow Tasks Architecture
  • Data Flow Tasks and ETL Architecture
  • Data Pipelines and Data Buffers

Basic ETL Entities in SSIS

  • SSIS Data Types and Data Conversions
  • SSIS Local and Global Variables
  • Dynamic Precedence Constraints
  • Dynamic Connection Managers in DFT
  • Data Flow Transformations and Usage
  • Handling ETL Enumerations in SSIS
  • ETl with Loops & Indexed Connections

SSIS Expressions & Package Debugging

  • Conditional Precedence Expressions
  • SSIS Parameters Usage and Variables
  • Control Flow Breakpoints - Usage
  • Data Flow Data Viewers and Audits
  • SSIS Expressions &Debugging Options
  • Debugging SSIS Packages & Limitations
  • Debugging Procedures in Realtime

Data Flow Transformations and ETL

  • Row and Column Transformations
  • Combining and Splitting Data
  • Performing SQL Database Operations
  • MERGE Vs UNION ALL Transformations
  • Lookup, Fuzzy Lookup and Grouping
  • SORT Vs AGGREGATE Transformations
  • OLE-DB Command Usage & Parameters
  • Derived Columns & Data Conversions
  • SSIS Parameter Mappings & Options
  • Tabular Data Stream & Commit Size
  • Table Locks & Batch Calculations

SSIS Customizations with .NET

  • SSIS SCRIPT Task (.NET) and Coding
  • Scripts for Control Flow Limitations
  • Scripts for Data Flow Limitations
  • ADO Connections and DataAdapters
  • Custom Code Handling in SSIS
  • Script Tasks & Notify Operators
  • SSIS Expressions and Iterations
  • Iterating Files and Scripts in SSIS
  • OLE DB Command - Internal Parameters
  • OLE DB Command - External Parameters

SCD Transformation - ETL / DW

  • Data Analytics and Column Profiling
  • Data Sampling and Data Delta
  • Type I and Type II SCD Examples
  • Dimension Table Design, Surrogate Keys
  • SCD - Business Keys and Attributes
  • SCD - Historical Attributes and Status
  • Event Notifications and Emails
  • ETL - Partial and Full Cache Options
  • Fact Table Loads and ETL Load IDs
  • PIVOT, UNPIVOT and WebService T/Fs
  • TDS Sizing and Memory Options

Change Data Capture (CDC) for ETL/DW

  • CDC Sources and Controls in SSIS
  • CDC Tables and Change Tracking
  • Dynamic DWH Connections & Logging
  • State Variables in CDC (ETL Scope)
  • CDC for Type I Dimension Loads
  • CDC for Type II Dimension Loads
  • Tuning CDC Pakages : States & Indexes

Checksum Operations for ETL/DW

  • CHECKSUM Transformation in DW
  • CACHE Transformation & Usage
  • Partial and Full Cache Options
  • SSIS Transactions & Isolation Levels
  • Checksum for Type 1 and Type 2
  • SSIS Checkpoints and Limitations

Master - Child Packages & Fact Loads

  • Configuring Master Packages, Parameters
  • Configuring Child Packages, Parameters
  • Parameter Bindings, Execute Process
  • Fact Loads with CDC Controls
  • OLE DB Transformation and Parameters
  • ADO.Net Connection Limitations in SSIS
  • Solutions to Data Delta Options

Events, Errors and Logging

  • SSIS Package Events and Audits
  • Package Level Event Handling Options
  • SSIS Event Bubbling Escalations
  • SSIS Logging & Project Connections
  • Windows Event Logs and SSIS Jobs
  • SQL Server Logging and Audit Tables
  • Global Connections and Project Audits
  • Logging Fuzzy Data Loads and ETL
  • Need For XML Connections & ADO
  • XML Connections & BLOB Data
  • Using SSIS Data Profile Viewer Task

SSIS Deployment Procedures

  • Project Builds & Bit Level Options
  • Creating ISPAC Files : SSIS 2014, 2012
  • Securing SSIS Manifest Files (PROD)
  • 64 bit and 32 bit Configurations
  • Validation & Verification Techniques
  • Configuration Options and Connections
  • Control Loops and Indexed Connections
  • Migrating ISPAC Files - Options
  • SSIS Package Backups and Passwords
  • Project Level Passwords and Encryption

SSIS Project Deployments

  • SSIS Deployment and SSIS Catalog DB
  • SSIS Catalog Project Files and Options
  • Security - Logins, Users, SSISAdmin
  • SSIS Catalog Folders in SSISDB
  • Post Deployments & Connections
  • Package Configurations, Parameters
  • SSIS Package Validations, Reports
  • Checksum Management and Encryptions
  • SSIS Package Scripts with T-SQL
  • Tuning Deployment and Configurations

SSIS Package Security

  • SSIS Package Security Options
  • Encrypting SSIS Catalog Packages
  • SSIS Package Store and SSISDB
  • Security Audits Reports and Limitations
  • SSIS Folder Level Security Options
  • Project Level Security and SSIS Roles

SSIS Loggins and Executions

  • SSIS Package Container and Memory
  • SSIS Package Logging and Events
  • SSIS Executions and DB Engine
  • Performance Reports and Auto SPs

SSIS Package Upgrades

  • SSIS Project Migration Utilities
  • Importing ISPAC and Manifest Files
  • SSIS Project Import Wizard - Usage
  • Upgrading Packages & Configurations
  • Command-Line Deployments & Options
  • Package Backup Procedures & Options
  • Scheduling Packages (Jobs), Operators
  • Upgrading SSIS 2012 to SSIS 2014
  • MSDB and SSIS Catalog DB Files
  • Comparing SSIS 2012 and 2014
  • SSIS ETL and DW - Comparisons
  • ETL - Staging - DWH : A Case Study


SSIS Training Curriculum : Download Brochure


Benefits of our SSIS Training Course:

After the SSIS Classroom Training participant should be able to:

  • Completely Practical and Realtime
  • Theory material provided in Advance
  • Highly Interactive and Interesting
  • Daily Tasks and Weekly Assignments
  • Certification Guidance and FAQs
  • 24x7 Server Access with Realtime DBs
  • Design and Understand Datawarehouses (DWH)
  • Decide to use SCD, CDC and Checksum Techniques
  • Implement ETL and Data Delta with Caching Techniques
  • Handle Events and Errors with Tuning Options
  • Perform .NET Scripting and Parameterized Fuzzy Operations
  • Deploy and Implement SSIS Package Security with Jobs


Our SSIS Classroom Training Sessions are completely practical, realtime. Register Today


Trainer : Mr. Sai Phanindra T, 9+ Yrs of Experience exclusively on SQL Server, SQL DBA, more..

Training Reviews

Register Now



SQL Server, SQL DBA, MSBI DWH Trainings


[+] More Courses

Register Today


Register Today For Free Demo