Data
integration issue Operational and Business Intelligence Integration
ETL (Extract Transform Load) tools available
Development environment BIDS (Business Intelligence Development Studio)
Support available: documentation, community, …

Workshop: Installation and presentation of the BIDS environment

Control Flow Tasks
Sequence / Loop Containers
Data Control Data
Source and Destination Management Data
Transformation and Scripting (VB.NET, C #)

Lab: Creating tasks, configuring data sources, running and observing statistics

Feeding Slowly Changing Dimensions (SCD)
Loading Fact Tables
Error Handling (Package Logging, Event Handler)
Using Data Viewers

Workshop: Basic and advanced debugging of tasks

Management of execution contexts
Optimization of tasks (parallelization, buffer sizing, etc.)
Configuration and deployment of packages
Execution modes and management of batch security

Workshop: Package deployment and implementation of optimization routines