Training & Certification

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

• Data Viewer

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