Microsoft Business Intelligence – MS BI SSIS Training

This course teaches how to build simple as well as complex data integration solutions using Microsoft SQL Server Integration Services. The course covers all aspects of development, deployment and administration of SSIS packages.
The course is based on SQL Server 2012, but it is relevant also for SQL Server 2005/2008/R2.

This course is delivered as 7-8 day classroom. It’s heavy on hands-on Lab exercises, Live Project, guided and evaluated by the trainer.
Trainer for this course is a MCA Degree holder Certified Instructor in the technology – with over 8 + years experience as a Developer and Trainer. Trainer have worked at MNC companies.
After Completion The SSIS Training Course. Trainee get Certification under our JK IT Solutions company.
Our dedicated team of expert trainer are available on email, phone and Skype chat to assist you with your queries. You can also use this facility after complete training.
Please speak to our team of expert training advisor for recommended next courses.
We are giving training on live project and individual attention. Allow only 5 student in batch. Our trainer will give 100% satisfaction of training.
SSIS training enables the student to understand the evolution of Integration Services and use it practically. We focus on not only theory of SSIS but completely practical sessions such that the student is confident to work on it after the SSIS training course. Its designed to simplify the complicated architecture and use it effectively.
After SSIS training course, the student would be able to:

  1. Be familiar with SSIS architecture and components
  2. Learn how to implement SSIS packages
  3. Learn how to implement logging in an SSIS package
  4. Be able to debug and implement error handling in an SSIS package
  5. Learn how to implement checkpoints and transactions in an SSIS package
  6. Learn how to configure and deploy an SSIS package
  7. Understand how to manage and secure an SSIS package
20 hours
  • SQL Server
Request a call back
Just Rs.7500+GST 18%
Syllabus

MS BI SSIS

1. Introduction to SQL Server Integration Services

  • SSIS Historical Overview
  • SSIS Architecture
  • Tools of the Trade
  • Creating a Simple Package
 2. SSIS Tools

  • Import and Export Wizard
  • SQL Server Data Tools
  • SQL Server Management Studio
  • Command-Line Utilities
3. SSIS Tasks

  • Looping and Sequence Tasks
  • Data Flow Task
  • Data Preparation Tasks
  • Workflow Tasks
  • Administration Tasks
  • Execute Package Task
  • Script Task (.NET)
 4.Working with Containers

  • Sequence Containers
  • Groups
  • For Loop Container
  • Foreach Loop Container
5.The Data Flow

  • Understanding the Data Flow
  • Sources & Destinations
  • Common Transformations
 6.Using Variables, Parameters and Expressions

  • Dynamic Package Objects
  • Understanding Data Types
  • Using Variables and Parameters
  • Working with Expressions
7.Loading a Data Warehouse

  • Data Profiling
  • Data Extraction and Cleansing
  • Dimension Table Loading
  • Fact Table Loading
  • SSAS Processing
 8.Accessing Heterogeneous Data

  • The Connection Managers
  • Excel and Access
  • Using XML and Web Services
  • Flat Files
  • Other Heterogeneous Sources
9.Error and Event Handling

  • Package Transactions
  • Using Precedence Constraints
  • Event Handling
  • Breakpoints
  • Error Rows
  • Logging




Submit your review
1
2
3
4
5
Submit
     
Cancel

Create your own review

Average rating:  
 0 reviews