SSIS Training

SSIS Training
4.5 1537

SQL Server SSIS Training Tool is structured to phrase the methods required to automate maintenance of SQL Server databases and updates to multidimensional cube data.

Date :
27 Apr 2017
Course Duration (Hrs):
Date :
28 Apr 2017
Course Duration (Hrs) :
Date :
29 Apr 2017
Course Duration (Hrs) :
Date :
30 Apr 2017
Course Duration (Hrs) :
Date :
05 May 2017
Course Duration (Hrs):
Date :
06 May 2017
Course Duration (Hrs) :
Date :
07 May 2017
Course Duration (Hrs) :
Contact Us Now!    

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that is created to perform a broad range of data migration tasks, data integration and workflow applications. 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. The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.

SSIS Training Overview

Learn to build and manage data integration solutions under expert guidance from our training team. Have an overview of the best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you’ll handle complex data integration scenarios more efficiently—and acquire the skills you need to build comprehensive solutions.

In SSIS online training, you will learn how to:

 Use SSIS to extract, transform, and load data from multiple data sources

Apply best practices to optimize package and project configuration and deployment

Manage security settings in the SSISDB catalog and control package access

Work with SSIS data quality features to profile, cleanse, and increase reliability

Monitor, troubleshoot, and tune SSIS solutions with advanced features such as detailed views and data taps

Load data incrementally to capture an easily consumable stream of insert, update, and delete activity


SSIS Training Curriculum

curriculum_moduleIntroduction 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

curriculum_moduleBasic 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

curriculum_moduleSSIS 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

curriculum_moduleData 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

curriculum_moduleSSIS 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 (.NET) Handling in SSIS

Script Tasks & Notify Operators

SSIS Expressions and Iterations

curriculum_moduleSCD 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

curriculum_moduleChecksum 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

curriculum_moduleChange Data Capture (CDC) for ETL/DW

CDC Sources and Controls in SSIS

CDC Tables and Change Tracking

Dynamic CDC Connections & Logging

Using CDC for Dimension Loads (ETL)

curriculum_moduleMaster – Child Packages & Fact Loads

Configuring Master Packages, Parameters

Configuring Child Packages, Parameters

Parameter Bindings, Execute Process

Fact Loads with SSIS CDC Controls

OLE DB Transformation and Parameters

ADO.Net Connection Limitations in SSIS

Solutions to Data Delta Options

curriculum_moduleEvents, 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

curriculum_moduleDeployment 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 SSIS ISPAC Files & Options

SSIS Package Backups and Passwords

Project Level Passwords and Encryption

curriculum_moduleSSIS Project Deployments

SSIS Deployment and SSIS Catalog DB

SSIS Catalog Project Files and Options

Security – Logins, Users, SSIS Admin

SSIS Catalog Folders in SSISDB

Post Deployments & Connections

Package Configurations, Parameters

SSIS Package Validations, Reports

SSIS Package Executions, Reports

Checksum Management and Encryptions

SSIS Package Scripts with T-SQL

Tuning Deployment and Configurations

SSIS Package Performance Reports

curriculum_moduleSSIS Package Security and Reports

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

Container and Package Logging

curriculum_moduleSSIS 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


SSIS Course FAQs

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of  the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE and other parts of the world. We are located in USA.

Mindmajix Technologies Inc

14 Pasco Drive
East Windsor, Connecticut, 06088
United States (US)
Phone: 201 378 0518


Job Support

Mindmajix Job support’s aim is to train and support as many young IT professionals as possible in achieving their tasks for attaining quality jobs in the regular workforce.

For a fresher in IT, the actual requirement of programming and development standards could be partially or completely different in the job environment. Job support gives graduates that extra guidance before or after they attempt employment into IT sector by assisting them with the SSIS training by highly experienced and real time professionals with full stack technical background in the SSIS field. They address your complete issues that you face periodically.

We have wide-spread services across India, USA, Australia and other countries, assisting software employed people to excel in their jobs when they have an onset of a worsening condition.

Our trainers support you solve your technical problem and guide you to the right path in order to obtain a favourable solution. Once we understand your project, the subsequent problems are solved even better and faster.

What we assure?

* Our trainers make it a point to make you capable of understanding the real world scenarios.

* Our trainers will provide exceptional Technical assistance and help you out solve your Technical problems at your jobs in an efficient way.

* We assist the person learn a new job, and ensure extra assistance or a different format for learning the role vividly.

We Specialize in providing most reliable support and you can entirely entrust to us.

Drop Us A Query

Course Reviews


1537 ratings
  • 51076
  • 4231
  • 3154
  • 261
  • 115
Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.