Spring Training Course Overview
Introduction to SQL Server Integration Services
- Product History
- Architecture overview
Business Intelligence Development Studio
- Introduction
- Package Designer
- Solution explorer
- Properties window
- Variables window
Control Flow Overview
- Connection Managers
- Precedence Constraints
Control Flow Task Detail
- Data Preparation Task
- File System Task
- FTP Task
- Web Services Task
- XML Task
- Data Profiling Task
- Execute Package Task
- Execute Process Task
Data Flow basics
- Data Sources
- ADO.NET Source
- Excel Source
- Flat File Source
- OLE DB Source
- XML Source
- Raw File Destination
Data Flow Transformations
- Row Transformations
- Copy Column
- Data Conversion
- Derived Column
- Union All
- Merge Join
Debugging Packages
Deployment Management
- The deployment utility
- Deployment options
- Deployment security
- Executing packages – DTExec and DTExecUI
Deployment Options & Utilities
- Package Execution Options
- File System Security Limitations
- SSIS Deployment & DB Engine
- SSIS Catalog Project Files
- Package Migration Utilities
- Command-Line Deployments
Security
- Security Options
- Encrypting SSIS Packages
- Event Logging Activities
Upgrading Packages
- Migrating packages
- DTS packages to SSIS migration