Intro to SSIS Part 2
Devin Knight MCTS, MCITP Sr. BI Consultant ([email protected])
Agenda o Data Flow o Variables and Expressions o Event Handlers o Administration
Data Flow o Sources (Extract) o Transformations (Transform) o Destinations (Load)
Creating a Data Flow
SSIS Variables o Variable Types o System o User
o Can Contain an Expression o Can be Updated Outside the Package o Use Across Packages (Parent & Child)
SSIS Expressions o Work together with Variables o Can be used on o Tasks o Connections o Variables
Using SSIS Variables and Expressions
Event Handlers o Can be Scoped on Different Items in Package o Use Control Flow Tasks o Great for Building Notification Alerts o Special System Variables for Errors
Using Event Handlers
Administering SSIS Packages o Using Configuration Settings o Deploying Packages o MSDB (Server) o File System
o Scheduling Packages
Deploying SSIS Packages
Thank You Questions: [email protected] Blog: http://www.bidn.com/blogs/DevinKnight Twitter: knight_devin
Agenda o Data Flow o Variables and Expressions o Event Handlers o Administration
Data Flow o Sources (Extract) o Transformations (Transform) o Destinations (Load)
Creating a Data Flow
SSIS Variables o Variable Types o System o User
o Can Contain an Expression o Can be Updated Outside the Package o Use Across Packages (Parent & Child)
SSIS Expressions o Work together with Variables o Can be used on o Tasks o Connections o Variables
Using SSIS Variables and Expressions
Event Handlers o Can be Scoped on Different Items in Package o Use Control Flow Tasks o Great for Building Notification Alerts o Special System Variables for Errors
Using Event Handlers
Administering SSIS Packages o Using Configuration Settings o Deploying Packages o MSDB (Server) o File System
o Scheduling Packages
Deploying SSIS Packages
Thank You Questions: [email protected] Blog: http://www.bidn.com/blogs/DevinKnight Twitter: knight_devin
