MBSI Microsoft Business Intelligence Online for advanced learners by Palium

Introduction to SQL Server Integration Services
o Introduction
o Product History
o Architecture overview
o Packages

Business Intelligence Development Studio
o Introduction
o Package Designer
o Toolbox
o Solution explorer
o Properties window
o Variables window

Control Flow Overview
o Introduction
o Connection Managers
o Tasks
o Precedence Constraints
o Containers

Control Flow Task Detail
o Introduction
o Data Preparation Task
o File System Task
o FTP Task
o Web Services Task
o XML Task
o Data Profiling Task
o Execute Package Task
o Execute Process Task

Data Flow basics
o Introduction
o Data Sources
o ADO.NET Source
o Excel Source
o Flat File Source
o OLE DB Source
o XML Source
o Raw File Destination

Data Flow Transformations
o Introductions
o Row Transformations
o Copy Column
o Data Conversion
o Derived Column
o Aggregate
o Sort
o Multicast
o Union All
o Merge
o Merge Join

Debugging Packages
o Debugging
o Breakpoints
o Data Viewer

Deployment Management
o The deployment utility
o Deployment options
o Deployment security
o Executing packages DTExec and DTExecUI

Deployment Options & Utilities
o Package Execution Options
o File System Security Limitations
o SSIS Deployment & DB Engine
o SSIS Catalog Project Files
o Package Migration Utilities
o Command-Line Deployments

Security
o Security Options
o Encrypting SSIS Packages
o Event Logging Activities

Upgrading Packages
o Migrating packages
o DTS packages to SSIS migration