Dynamic SSIS Sswug

Mike Davis, MCTS, Sr. BI Consultant ([email protected])

Agenda o Expressions o Variables o Configuration Files o Parent & Child Packages

Dynamic SSIS Packages o No Hard Coding – Use Variables o Child Packages o Configuration Files or Table o Environment Variables

SSIS Expressions o Work together with Variables o Can be used on o Tasks o Connections o Variables o Disadvantage: Difficult to manage a large number of expressions

Creating SSIS Expressions

SSIS Variables o Can Contain an Expression o Can be Updated outside the Package o Use Across Packages (Parent & Child) o Reduce Re-Deployments

Using SSIS Variables and Expressions

SSIS Configuration Files o Exist outside the Package o Plain Text (Security Concerns) o Used across Multiple Packages o Set up per Connection or per Package

Using SSIS Configuration Files

Using Parent and Child Packages o Parent can Pass Variables to Child o Child Package can be used by Multiple Parents o Reduce duplicate coding

SSIS Parent &Child Packages

Schedules with Configuration Files o Configuration files on any package o Different Configuration on Schedules o Package may not have Configuration o No Need to redeploy, just add the Configuration File to the Schedule

Scheduling with Configuration

Thank You o [email protected] o SSIS Personal Trainer is Available on Amazon.com o BIDN.com/Blogs/MikeDavis