LiveZilla Live Chat Software
Download syllabus copy Download printable copy



Microsoft says that SQL Server Integration Services (SSIS) “is a platform for building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.” A simpler way to think of SSIS is that it's the solution for automating data movements. SSIS provides a way to build packages made up of tasks that can move data around from place to place and alter it on the way.

Though SSIS is almost infinitely customizable, Microsoft has produced a simple wizard to handle some of the most common ETL tasks: importing data to or exporting data from a SQL Server database. The Import and Export Wizard protects you from the complexity of SSIS while allowing you to move data between any of these data sources



MSBI incl. SSRS, SSIS and SSAS Objectives

  • To understand MSBI application development Lifecycle.
  • To understand basic Data Warehousing Concepts
  • To understand the Concept of OLTP and OLAP
  • To Use SSDT (SQL Server Data Tools) in detail for development of SSIS packages.
  • To learn SSIS Architecture, Components of SSIS.
  • To gain complete understanding of different control flow tasks, containers and precedence constraints.
  • To gain complete understanding of wide variety of data flow Sources, Transformations and Destinations.
  • To learn to work with variables, data types, functions, expressions and parameters and providing Dynamism in SSIS
  • To develop packages using different tasks and different Transformations based on real time requirements.
  • To learn working with event handler, Logging, Configuration Files.
  • To learn Error Handling and Debugging in SSIS.
  • To learn package deployment and project deployment.
  • To gain understanding of Security and Package management.


SQL Server 2012

MSBI incl. SSRS, SSIS and SSAS Duration

2 months

MSBI incl. SSRS, SSIS and SSAS Syllabus

  1. What is SSIS?
  2. Need for SSIS
  3. BIDS and SSMS tools
  4. SSIS and DTS Comparison
  1. Launching BIDS
  2. The package designer
  3. The Toolbox
  4. Solution Explorer
  5. The Properties window
  6. The Variables window
  7. The SSIS menu
  1. Runtime Engine Dataflow Engine
  2. Object Model
  3. SSIS Service
  4. Buffer Management
  5. Creating SSIS Packages
  6. Solution, project and package creation
  7. Simple package creation using import export wizard
  8. Simple packages creation for data movement between (Flat file, xml, raw,database etc)
  1. Control flow overview
  2. Working with containers
    1. For each loop
    2. For loop
    3.  Sequence
    4.  Handling Enumerations
  3. Working with tasks
    1. . Execute SQL Task
    2. . Bulk Insert Task
    3. . File System Task
    4.  FTP Task
    5.  Transfer Database Task
    6.  Backup database task
    7.  Script task
    8.  Execute process task

Vandana Soni

A well known trainer at Deccansoft for more than 6 years, she is a specialist in SQL Server and has taught well over 80 batches. Her uniqueness lies in conducting her classes with ease and clarity, making her students understand even the most complex queries. more

Email Id
Contact No
Scroll to Top