Intro to SSIS Part 1

Devin Knight MCTS, MCITP Sr. BI Consultant ([email protected])

Agenda o Why use SSIS o Development Environment o Control Flow o Tasks and Containers

The Case for SSIS SQL Server

DB2

Oracle

.CSV

SSIS (ETL)

Data Warehouse

Development Environment oBusiness Intelligence Development Studio (BIDS) oPackages oData Sources

Getting Started in BIDS

Control Flow o Precedence Constraints o Tasks o Logging

Using the Precendence Constraints

Control Flow Tasks and Containers o Executing SQL Statements o .Net in SSIS o File Operations o Looping

Using Common Tasks and Containers

Thank You Questions: [email protected] Blog: http://www.bidn.com/blogs/DevinKnight Twitter: knight_devin