SSIS Training

MSBI Training Chennai provides real-time and placement focused SSIS training in chennai with real-time project scenarios. We provide world-class Microsoft BI certification and placement training in SSIS, SSAS, SSRS and SQL Server DBA. We can guarantee classes that makes you as a Microsoft BI Expert. The Best SSIS Training course that is exclusively designed with Basics through Advanced Microsoft BI Concepts. SSIS Certification and Interview Guidance are provided during the course. All our training sessions are Completely Practical and Real Time.

Microsoft BI Training Courses in Chennai

SSIS Training Course Content

SQL Server Integration Services (SSIS) Training Course Content

SSIS provides SQL Server Coding enhancements, Administration Options and Customizations for SQL Server Developers, Administrators, BI Engineers and Data Analysts.In our Training, we deal with complete SSIS features including SCD, Profiling, Tuning and Customizations. Each sessions will be completely practical. Daily tasks and a Case Study will also be provided.

Introduction to SSIS

  • Need for SSIS
  • SSIS Development Environment
  • SSIS Tools and DTS Comparisions

SSIS Architecture

  • Control Flow Tasks Architecture
  • Data Flow Tasks Architecture
  • Data Pipelines and Usage
  • Conditional Precedence

Basic SSIS Entities

  • SSIS Data Types and Conversions
  • SSIS Local & Global Variables
  • Dynamic Precedence Constraints
  • Dynamic Connection Managers
  • Data Flow Transformations usage
  • Handling Enumerations in SSIS

SSIS Customizations

  • SCRIPT  Task (.NET) in SSIS
  • Expressions and Iterations

SSIS Expressions & Debugging

  • Expression Builder Usage
  • SSIS Parameters Usage and Variable
  • Control Flow Breakpoints
  • Data Flow Data Viewers and Audits
  • Limitations of SSIS Debugging

Data Flow Transformations

  • Column Transformations
  • Combining and splitting data
  • Performing database operations
  • MERGE Vs UNION ALL Transformations
  • Lookup and Fuzzy Grouping
  • SORT Vs AGGREGATE Transformations
  • OLE-DB Command Tranformation

Custom Activities

  • Data Analytics and Debugging
  • Custom Code Handling
  • Event Notifications and Emails
  • Data Sampling Techniques
  • Type I and Type II SCDs
  • Performing PIVOT operations
  • TDS Sizing and Tuning Options

Package Controls

  • SSIS Transactions & Isolation Levels
  • SSIS Checkpoints and Usage
  • CACHE Transformation & Performance
  • CHECKSUM Transformation

Package Configurations

  • Configurations and benefits
  • Applying Configuration Options
  • Global Configurations in DENALI
  • Choosing correct providers

Error Handling

  • System Events and Audits
  • Package Event Handling
  • Limitations of Event Handling
  • Event Bubbling Escalations

SSIS Logging Actions

  • Benefit of SSIS Logging
  • Environment Variables Usage
  • Windows Event Logs and SSIS
  • SQL Server Logging Limitations
  • Choosing correct log providers
  • Package Execution Audits

Processing XML Data

  • Iterating XML nodes and Data
  • Data Profiler & ADO Connections

Deployment Procedures

  • Preparing for Deployment
  • SSIS Deployment Phases
  • Securing Manifest Files
  • Deployment Options & ISPAC
  • Validation & Verification Techniques

File System Deployment

  • File System Deployment
  • Package Execution Options
  • File System Security

SQL Server Deployment

  • SQL Server Deployment
  • SSIS Catalog Files and Security
  • SQL Server Security
  • File System Versus MSDB

Deployment Management

  • Package Migration Utilities
  • Command-Line Deployments
  • Package Backup Procedures
  • Fine-tuning Deployment

Managing Security

  • SSIS Package Security Options
  • Encrypting SSIS packages
  • Package Store and msdb
  • Security Audits and Proxies
  • MSDB and File System Comparisions
  • Event Logging Activities

Upgrading Packages

  • DTS packages to SSIS migration
  • Upgrading 2005 Packages to 2008
  • MSDB and SSIS Catalog Files
  • Comparing SSIS 2008 R2 & 2012
  • ISPAC (DENALI) & Package Migrations

SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.  While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just DW; e.g. when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created.  At a high level, SSIS provides the ability to:

  • retrieve data from just about any source
  • perform various transformations on the data; e.g. convert from one type to another, convert to uppercase or lowercase, perform calculations, etc.
  • load data into just about any source
  • define a workflow

The first version of SSIS was released with SQL Server 2005.  SSIS is a replacement for Data Transformation Services (DTS) which was available with SQL Server 7.0 and SQL Server 2000.  SSIS builds on the capabilities introduced with DTS.

In this tutorial we will step through a number of topics that you need to understand in order to successfully build an SSIS package.  Our high level outline is as follows:

  • Creating SSIS packages with SQL Server Management Studio (SSMS)
  • Business Intelligence Development Studio (BIDS)
  • Creating a simple SSIS package in BIDS
  • Deploying SSIS packages
  • Executing SSIS packages

SSIS Training Course Highlights:

  • 1) Two days free trial - If candidate likes this course, these days are adjusted in his actual schedule.
  • 2) Live Project Exposure of Fortune companies.
  • 3) Training by Subject Matter experts from CMM Level 5 companies
  • 4) Running in two major financial cities of India – Chennai and Mumbai
  • 5) Worldwide Classroom training of Datawarehouse and corporate classes at affordable fees.
  • 6) Our basic course worth more than the advanced course of other institutes/freelancers.
  • 7) Free Interview preparations.
  • 8) 100% free assistance for SSIS certifications.
  • 9) 100 % guarantee in succeeding the certification at affordable fees.
  • 10) Also provide Classroom training to students of foreign countries.
  • Learn SSIS Training from the Best Datawarehouse Institute in Chennai

SSIS Training Locations in Chennai

Greens Technology
15 First Street Padmanabha Nagar, Adyar, Chennai
Tel: +91- 89399 15577
      +91- 89399 25577

SSIS Training Reviews

Greens Technology Reviews given by our students already completed the training with us. Please give your feedback as well if you are a student.