A Guided Tour of SSIS
Understanding SSIS
Exploring and Executing an SSIS Package in BIDS
Exploring and Executing a Package Outside BIDS
Introduction to Control Flow
Overview of Control Flow in SSIS
Control Flow Tasks
Workflow Tasks
Other SQL Server Operations Tasks
Precedence Constraints
Data Processing Tasks
Introduction to Data Flows
Data Flow Overview
Data Flow Pipeline
Data Flow Sources
Data Flow Destination
Data Viewers
Data Flow Transformations
Variables and Configurations
Understanding Variables
Using Variables in Control Flow
Using Variables in Data Flow
Understanding Property Expressions
Using Property Expressions
Understanding Configurations
Using Configurations
Using Variables and Configurations between Packages
Advanced Control Flow
Synchronous Transformations
Asynchronous Transformations
Working with Error Outputs
Using Advanced Transformations
Package Deployment
Overview of Deploying Packages
Deployment Challenges
Create a Package Deployment Utility
The Package Installation Wizard
Deploy a Package to the File System
Deploy a Package to SQL Server
Redeploying Updated Packages
Package Management
Overview of Package Management
Managing Packages with DTUtil
Managing Packages with SQL Server Management Studio
Executing Packages
Scheduling Packages with SQL Server Agent
SSIS Security
Introduction to Scripting and Custom Components
Extending SSIS Capabilities through Code
SSIS Scripting
Scripting in Control Flows
Scripting in Data Flows
Script Compilation
Custom SSIS Components
Best Practices
Best Practices for Using SSIS
Best Practices for Package Design
Data Flow Best Practices
Beyond ETL: Other Scenarios for SSIS
Using SSIS beyond ETL
Migrating SQL Servers with SSIS
SQL Server Maintenance Plans
Working with Analysis Services
Folder and File Management
Working with the Windows Event Log