India : +91 9502991277
    VOIP: +1 408 876 4444
Email : online@mindqsystems.com
Latest Online Courses >> Microsoft .net and sharepoint
Follow us on :

SSIS

During this Microsoft Business Intelligence [MSBI] training program, you will dive into Designing an ETL Solution Architecture Using Microsoft SQL Server Integration Services and Implementing and Maintaining Microsoft SQL Server Integration Services. In addition, we will extensively cover how to Design an Analysis Solution Architecture Using Microsoft SQL Server Analysis Services and Implement and Maintain Microsoft SQL Server Analysis Services. You will expand your knowledge on MDX Queries and learn how to create complex reports employing expressions, global collections, and conditional formatting using SQL Server Reporting Services.

Overview

Pre-Requisites

Course Content

Integration services overview

  • Product History
  • SSIS Package Architecture Overview
  • Development and Management Tools
  • Source Control for SSIS Packages

Pre-Requisites:

No prior experience is presumed.

Hands-on/Lecture Ratio

This class is 70% hands-on, 30% lecture.

Software Needed on Each Student PC

  • Windows Server 2003 or 2012, Windows XP Professional, with at least 1GB RAM
  • SQL Server 2012/2005 and Business Intelligence Components

SSIS Using SSMS

  • The Import and Export Wizard
  • Importing and Exporting Data
  • Working with Packages
  • Database Maintenance Plans
  • Creating Database Maintenance Plans using SSMS

SQL Server Data Tools

  • Launching Data Tools
  • Project templates
  • The package designer
  • The Toolbox
  • Solution Explorer
  • The Properties window
  • The Variables window
  • The SSIS menu

Introduction to Control Flow

  • Control Flow Overview
  • Precedence Constraints
  • The Execute SQL Task
  • The Bulk Insert Task
  • The File System Task
  • The FTP Task
  • The Send Mail Task and other Control Flow Items.
  • Case Study on Usage of ControlFlow items.

Advanced Control Flow

  • Containers – grouping and looping
  • The Analysis Services tasks
  • The Execute Process Task
  • The Execute Package Task
  • Case Study on Usage of Execute Package Tasks for Zipping and Unzipping Files.
  • The Data Mining Query Transformation
  • The Data Mining Model Training Destination
  • The Slowly Changing Dimension Transformation.
  • Demo of Adv. Dataflow Items.

Extending SSIS through Custom Code

  • Introduction to SSIS scripting
  • The SSIS script editor
  • The SSIS object model
  • Script in Control flow: The Script Task
  • Script in Data flow: The Script Component
  • Introduction to SSIS component development
  • Case Study on Creation of Master and Child Packages using Execute Package Task.

Introduction to Data Flow

  • Data Flow Overview
  • Data Sources
  • Data Destinations
  • Data Transformations overview
  • Commonly Used Transformations.
  • Case Study for usage of Transformations and Other Dataflow components.

Variables and Configurations

  • Variables Overview
  • Variable scope
  • SSIS system variables
  • Using variables in control flow
  • Using variables in data flow
  • Using variables to pass information between packages.
  • Examples of usage of Variables and Usage of expressions.
  • Configuration Overview

Debugging, Error Handling and Logging

  • SSIS debugging overview
  • Breakpoints in SSIS
  • SSIS debugging windows
  • Control Flow: The OnError event handler
  • Data Flow: Error data flow
  • Configuring Package Logging.
  • Demonstration of Logging and Configurations using a Sample Case Study.

Advanced Data Flow

  • Revisiting data sources and destinations
  • The Lookup Transformation
  • Getting Fuzzy: The Fuzzy Lookup and Fuzzy Grouping Transformations
  • The Multicast Transformation
  • The Merge and Merge Join Transformations

SSIS Package Deployment

  • Configurations and deployment
  • The deployment utility
  • Deployment options
  • Deploying and Managing SSIS Packages
  • Deployment security
  • Executing packages – DTExec and DTExecUI

SSIS Package Management

  • The SSIS Service and Managing packages with DTUtil
  • Managing packages with SQL Server Management Studio
  • Scheduling packages with SQL Server Agent

Applying SSIS to Data Warehousing

  • Data Warehouse Concepts
  • Populating Data Warehouse Structures using SSIS
  • SSIS General Principles

* For all the above topics there will be a Demo and Lab session. Case studies will be provided based on the scenario.

For Detailed Course Contents Click here
For Upcoming Class Room Batches Click here

For Registration      

  • Firehouse
  • Chloe nightclub
  • Firehouse bar
  • Firehouse chloe club fishtank
  • Firehouse restaurant
  • Firehouse