SSIS Online Training with ETL & DW (LIVE, Instructor Led)

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 LIVE Online Training, we deal with complete SSIS Design and Development including SCDProfilingTuning and Fact Loads. All sessions are completely practical and realtime.

Pre-requisites: Participant needs to have knowledge on SQL Server T-SQL Queries to join our Real-time Practical MSBI Training Course.

SSIS LIVE Online Training Plans

Total Number of Sessions 13 Classes 15+ Classes
Type of Training Real-time Real-time
Theory : Practice Ratio 10 % : 90 % 10 % : 90 %
Interviews & Resume
Real-time Project
MCSA Certification Guidance
Total Course Duration 2 Weeks 2.5 Weeks
Total Course Fee INR 6000/-
USD 100
INR 8000/-
USD 140

SSIS Online Training Course Contents:

Part I : Basic SSIS Development & ETL - DWH

Part II : Advanced SSIS Development & Deployments


  • Need for SQL Server Integration Services (SSIS) & ETL / DWH
  • Advantages of SSIS for Data Loads, ETL, DataWarehouse
  • SSIS Tools : SSDT (SQL Server Data Tools), ETL Wizards
  • SSIS Design / Development & LIVE (Deployment) Environment
  • Understanding Data Warehouse (DWH) Design & ETL Process
  • DWH and ETL Structures, Implementations with MSBI SSIS
  • SSIS ETL Operations for Data Reads, Data Cleansing, DWH
  • Data Warehouse (DWH) Design Principles and Design Plan
  • SSIS 2016 and SSIS 2017 : SSIS Database Installations
  • Understanding SSIS Catalog DB Encryptions and CLR / Startup
  • SSIS Database and Catalog Folders - Purpose, Passwords
  • SSIS 2016, 2017 Configuration and DB Catalog Encryptions
  • SSIS Catalog Database (SSIS DB) : Creation, Verification
  • SSDT Tool: SQL Server Data Tools - SSDT / Visual Studio Shell
  • SSDT 2015 Installation and Verification of SSIS Templates
  • SSDT 2013 Installation and Verification of SSIS Templates
  • SSIS Package Environment and SSDT Project Creation
  • SSIS Solutions and Project Templates - Verifications
  • Version Control Options and SSIS Design Plan - Tools Usage
  • SSIS Online Training - Lab Plan, Resources & Databases


  • Need for Checksum Transformation in ETL Data Loads
  • Configuring Checksum Transformation : 2014, 2016 Versions
  • Checksum Transformation Logic & Parity Checks (CRC)
  • Generating Checksum Values @ Type I, Type II ETL Changes
  • DWH Dimension Tables With Checksum Transformation
  • Working with Parity Bits, Conditional Lookup Transformation
  • Row Redirection Options & Lookup Match, NonMatch Output
  • OLE DB Command: SQL Statements and Input Parameters
  • Parameter Mapping and Dynamic SQL for Row Updates
  • Cache Transformation with Memory Loads, CAW Files (VM)
  • Memory Connections and Reuse. Lookup with Cache Options
  • Tuning Lookup Transformation: Caching & Index Options
  • FULL CACHE : Usage Options. NO CACHE: Usage Options
  • PARTIAL CACHE : Precautions. Data Splits, Fast Loads
  • Cache Connection Manager, Performance Tuning @ ETL
  • Pre-ETL Data Load Operations with Memory Connections
  • Lookup with NOCACHE Options. Advantages, Precautions
  • Understanding Dependent Data Flow Tasks and Usage
  • SSIS Package Internal Parameters and Query Updates
  • OLEDB Command with Conditional Splits, Multi Row Updates


  • Understanding SSIS Developer Environment (SSDT) Interface
  • Basic Vocabulary - SSIS, ETL, DWH, Data Flow, Data Buffer
  • Control Flow Tasks - Architecture, Purpose and Usage
  • Data Flow Tasks - Architecture, Purpose and Usage
  • Creating SSIS Packages For Basic Data Flow Operations
  • SSIS Solutions, Projects and Package Creation. Tasks
  • Need For Data Pipelines & Connections in Data Flow Tasks
  • Basic Data Extraction Drivers / Providers with Data Flow
  • Using OLE DB and SQL Server Connections - Usage
  • SSIS Package Creation Process - Using Control Flow Items
  • SSPI Interface Connections, Data Source, Initial Catalog
  • Using DTSX Files for SSIS Package Execution. Audits
  • SSIS Execution Context, SSIS Package Errors and Logs
  • Using Source Assistants, Destination Assistants in SSIS
  • DAT File Imports, Data Flow Options, Adding Annotations
  • Common SSIS Package Errors & Solutions in Real-time
  • SSIS Project Configuration Options - Debugging, Bit Config
  • SSIS 64 Bit and 32 Bit Configuration Settings and Options


  • System.Data.SQLClient Managed Providers: Usage Options
  • Dynamic Connections and Loops with SSIS Expressions
  • SSIS Expressions with Variables For File Specifications
  • For Each Expressions - Dynamic File Types, Directories
  • Variable Mapping with Indexed Connections. Performance
  • XML Queries, Options @ Sub Queries. XML Data Imports
  • RAW Files - DTSPipeline Wrapper & RAW Adapters
  • Row Sampling and Percentage Sampling Options
  • SSIS Logging - Text Files and sysssislog Tables @ Audits
  • Package Logging and Container Events for Execution
  • SSIS Logging Options and Connections. Verifications
  • SSIS Data Profiler Tool, ADO.NET Connections and XML
  • SQL Data Profile Viewer Tool - Usage with XML Files
  • Nullability Checks and Fast Load Options @ Row Size
  • ADO.NET Connections for SQL Profiler Tool, Options
  • Time-Out Options for Quick Profile, Candidate Keys
  • Value and Length Distribution, Surrogate Key Detection
  • XML File Imports for SQL Profiler Viewer Tool, Options


  • Understanding ETL and DWH Implementations - Strategies
  • Bulk Load Operations and Data Import Options in SSIS
  • Bypass Prepare and Execution Options with SQL Task
  • Historical Data Loads (Type II) and Incremental Updates
  • Debugging Controls in SSIS - Variants and Limitations
  • Data Flow Debugging Controls and Data Viewer Options
  • Synchronous & Asynchronous Transformations, Data Loads
  • Row and Partial Blocking Transformations. Buffer Reuse
  • Fully Blocking Transformations - Buffer Reuse Restrictions
  • Examples to Avoid Fully Blocking Transformation in SSIS
  • Advanced Options and Input / Output with Excel Sources
  • Excel Connections, Sheets, & Memory References - Usage
  • MERGE Transformation and UNION ALL Transformation
  • SORT Transformation, NOSORT Options, Advanced Sort
  • Data Conversion Transformation and SSIS Expressions
  • Data Flow Transformation: Conditional Split, Expressions
  • Transactions & Batch Scoped Data Loads with SSIS Packages
  • Comparing Regular Loads and Fast loads in ETL / DW


  • Fact Table - Design and Implementation Rules, ER Model
  • Fact Table Design with STAR and SNOWFLAKE Schemas
  • Time Dimensions - Purpose, Usage and ETL Date / Time
  • Generating Time Dimensions for ETL, Load Identification
  • Linking Time Dimensions to Fact Loads, Lookup Operations
  • Caching Options in Lookup. Dimension Loads, Key Lookups
  • Parent-Child Packages for Dimension,Fact Table Loads
  • Master Package Design: Dimension, Fact Load Integration
  • Inferred Members and Status for NULLs in Dimensions
  • Parameter Mapping for ETL Updates, Component Properties
  • ETL Load Date IDs & Expressions for Dimension Keys
  • Error Handling & Event Handling with Master Packages
  • Project Connections, Parameters in Master-Child Packages
  • Key Based Dimension LOOKUPs and Indexes. Fast Loads
  • SCD Implementations with Legacy Data. ETL Load Types
  • Fact Load Design for Initial Loads, Incremental Updates
  • End-to-End Data Warehouse Design & .NET Scripts
  • STAR & SNOWFLAKE Schemas for DWH - Data Modeling


  • Importing Legacy Data, Need for Data Cleansing, Formatting
  • PIVOT Transformation, Data Reads, Connection Assistant
  • Pivot Usage Values - Purpose and Implementation. Key Values
  • Lineage ID in SSIS - Purpose, Usage. Column Mappings
  • Data Exchange Operations with Pivot Keys and Pivot Values
  • Using Data Viewer (Debugging) for Data Transfer Verifications
  • Debugging with Detach/Attach, Memory Buffer & Row Counts
  • Fuzzy Lookup Transformation, Reference Table Connections
  • Exact, Fuzzy and Nomatch Data Cleansing with Conditional Split
  • Index Creation, Maintenance for Faster Lookup Transformation
  • Data Conversion Transformation - Usage. Derived Columns
  • Data Conversion Transformation - NVARHAR, VARCHAR Data
  • Explicit Data Type Conversions and Usage. Error Redirections
  • SSIS Package/Project Conversions - Process and Options
  • Text Qualifiers and Data Loads with Flat File Sources (.dat)
  • SSIS Expressions and Package Debugging, Break Points
  • Transaction Options For SSIS Executables - Package Level
  • Precedence Constraints - Success/Failure/Completion Settings
  • Parallel and Sequential Task Executions. Options, Usability


  • Script Task - Purpose and Working in SSIS Control Flow
  • Script Task - Usage with VB.NET Programs. Compilations
  • Script Task - Usage with C#.NET Programs. Compilations
  • Variables and Parameters with SSIS Script Task. Usage
  • Read Only and Read Write Variables. Expressions, Mapping
  • Namespace Options, Customizations : System.IO, DTS
  • Using VB.NET, C#.NET Scripting Programs with Parameters
  • Data Flow Limitations : Solutions with .NET Scripting
  • SSIS Variables and Parameters - Mapping Expressions
  • Understanding Control Flow - Sequence Containers, Usage
  • Using Control Flow File System Tasks and Limitations
  • Using .Net Scripting for SQL Server Data Reads/Writes
  • SQLDataAdapters & System.Data.SQLClient Connections
  • Script Task for Data Writes and Row Level Formatting
  • Adding DTS Packages to SSIS Projects (Data Tools)
  • Using Variables and Parameters for SSIS Script Task
  • Script Component in Data Flow Task - Usage Options
  • Script Component - Input, Output and Transformations
  • Using Script Task for Control Flow, Data Flow Limitations


Revision of Previous Concepts ** Mock Interview ** Missing Concepts from the course Curriculum (if any) ** Certification Guidance ** Mock Certification ** Resume Points

DAY 12

Revision of Previous Concepts ** Mock Interview ** Missing Concepts from the course Curriculum (if any) ** Certification Guidance ** Mock Certification ** Resume Points


  • Sales Scenario for OLTP Database to Historical Data Loads
  • Introduction to Datawarehouse (DWH) - Purpose, Usage, Access
  • Dimension Tables, Fact Tables and Relations, Inferred Members
  • TYPE1 and TYPE2 Changes. ETL Implementation Techniques
  • Implementing Type I Changes (SCD) for DWH in Sales Scenario
  • Dimensional Table Design for DWH using SCD - Type 1, Type 2
  • Data Loads with Legacy Files (DAT, TXT, CSV), Data Marts
  • Surrogate Keys and Alternate Business Keys - Purpose, Usage
  • Identity Columns, Key Values in DWH. Business Key Limitations
  • Changes to Fixed Attributes, Changing Attributes. Observations
  • Changes to Historical Attributes. Inferred Member Updated
  • ETL Date Fields, Row Status Values and Transformations
  • Naming Conventions For SSIS Entities, Options & Reusability
  • Designing Dimensions for DW - Incremental, Historical Loads
  • OLE DB Connections for Incremental Loads in Datawarehouse
  • Identity Property and Attribute Key Types in SCD, Limitations
  • Historical Attributes and Data Delta Operations, Identification
  • SSIS SCD Transformation Limitations and Real-time Issues
  • SCD Transformation with OLE-DB Command Transformation


  • SSISDB Catalog Deployments - Process, ISPAC File Structure
  • SSIS Package Builds, Verification Techniques, Scripts
  • SSIS Project Deployment Wizard : Targets and Logging
  • SSIS Package Deployments - Need, Options and Tools
  • SSIS DB Catalog Folders - Creation, Usage. Properties
  • SSIS DB Catalog Projects For Project Deployments
  • SSIS Package Executions - Scripts, Reports, Messages
  • Package Validations - Scripts, Reports, 32/64 bit Options
  • Package Configurations - Parameter Management, Scripts
  • SSIS Package Jobs from SQL Server Agent. SSIS Job Steps
  • SSIS Job Schedules and Notifications: Windows Event Logs
  • SQLISPackage130 Events and Error Logs. Package Monitoring
  • Package Security Management - SSISDB Logins and Users
  • ssis_admin, ssis_failover_monitoring_agent, ssis_logreader
  • Folder Level and Project Level Security Implementation
  • Execute/Write/Folder Security Content Management Roles
  • Business Intelligence Development Studio: SSIS BIDS
  • Project Migration Utilities in SSIS, SSIS Project Passwords
  • Importing ISPAC Files, SSIS Projects. Re-Engineering


  • Threshold Values Selection, Search Delimiters and Options
  • Data Pipeline with _Similarity & _Confidence Columns
  • ForEach Loop Container. File Level Connections, Variables
  • Defining Variables for Connections. DFT and Control Flow
  • Dynamic Connections with Variables. For Loop Container
  • Connection Iterations, Connection Fetch and Index Mapping
  • Local and Global Connections. Naming Conventions
  • Post ETL, Derived Column and Fuzzy Transformations
  • SSIS Configurations, Usage. Dynamic Connection Values
  • SSIS Package Level Rollbacks and Restart Execution Options
  • Checkpoint Files and SSIS Logging Options - Package, Tasks
  • Checkpoint Options - Advantages, Usage and Limitations
  • Dynamic Connection Managers - Precedence Constraints
  • FailPackageOnFailure and Checkpoint Property Usage
  • Transaction Property : REQUIRED / (NOT)SUPPORTED
  • Transaction Property Versus CHECKPOINT Files, Usage
  • Parent - Child Package Design in SSIS, Parameter Binding
  • Master Packages and Child Packages, Derived Columns
  • Defining Local and Global Variables / Parameters
  • Parameter Bindings with Parent - Child Packages in SSIS


Applicable for Plan B
  • Advanced Connection Options - XML, DT_NTEXT Stream
  • XML Connections & Usage. Reading, Operating XML Data
  • Column Statistics and SSIS Data Profile Viewer Tool
  • Direct Data Loads and Data Stage Operations for DWH DBs
  • DML Audits using Change Data Capture (SQL Server)
  • Understanding CDC Tables with SQL Server Connections
  • DML Audits: Inserts, Deletes, Values before/after Updates
  • CDC Source Connections - Usage, ADO.NET Integration
  • CDC Control Flow Tasks and CDC State Tasks. Values
  • SSIS CDC Source Connections with Net Support Changes
  • Adding DTS, Older SSIS Packages & Package Upgrades
  • Creating Packages, SMO Connection with BIDS. Project Builds
  • Command-Line Deployments For SSIS, Execution Utilities
  • Advantages of SSIS ETL/DW Procedures and Data Audits
  • SSIS Packages for Database Migrations - Online/Offline
  • Database Copy & Move Options. Pre, Post Migration Tasks
  • Package Refresh Options, Package Upgrade Properties
  • Using State Variables and Controls. Storing States
LIVE SSIS Online Training Course Curriculum : Brochure Download

Our SSIS Online Trainings are completely practical, realtime. Register today for free Demo


Benefits of our SSIS Training Course :

  • 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

After the SSIS Online Training course participants should be able to:

  • 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
  • Implement STAR & SNOWFLAKE Schemas with Fuzzy Operations
  • Deploy and Implement SSIS Package Security with Jobs

SQL Server, SQL DBA, MSBI DWH Trainings :