MindQ are pioners in offering real time industrail experts hands MSBI(SSIS, SSAS, SSRS) training.
along with Real Time Project senarios. All the sessions are completely PRACTICAL.
MSBI (MICROSOFT BUSINESS INTELLIGENCE) - SQL SERVER 2008 (SSIS, SSAS, SSRS)
SSIS Course Objectives:
Module 1: Architecture and Introduction to SQL Server Integration Services
Need for SSIS
SSIS and DTS Comparison
SSIS Architecture
Control Flow Architecture
Data Flow Architecture
Data Pipeline Usage
Precedence Constraints
SSIS Event Handler
SSIS Components
SSIS Development Studio - BIDS
SSIS Runtime Services
SSIS Package Deployment
SSIS Folders and File Structure
Module 2: Designing and Implementation of SSIS packages
SSIS Data Types,
SSIS Variables,
Connection Managers
Data Flow Tasks usage
SSIS Expressions
Module 3: Designing and Implementation of Control Flow & Data Flow.
Control Flow
For Loop Container
For each Loop Container
Sequence Container
Bulk Insert Task
Data Flow Task
Execute Package Task
Execute SQL Task
File System Task
FTP Task
Script Task
Send Mail Task
Transfer Database Task
WMI Data Reader Task WMI Event Watcher Task XML Task
Maintenance Plan Task Backup Database Task Shrink Database Task.
Row Transformation:
Character Map Transformation
Copy Column Transformation
Data Conversion Transformation Derived Column Transformation
Script Component Transformation OLEDB Command transformation
Rowset Transformation.


* Resume preparation and Interview assistance will be provided.

For any further details please contact +91-9502991277 or
visit www.mindqonline.com
Please mail your queries to online@mindqsystems.com

Author: Mohammad

Related Posts: