Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Appendix B

Problem and Solution Crib Notes

This appendix is a result of the culmination of many student questions over years of teaching SSIS classes. After a week of training, students would typically say, “Great, but can you boil it down to a few pages of crib notes for me?” The following table shows you common problems you’re going to want to solve in SSIS and a quick solution on how to solve them. These solutions are just crib notes, and you can find most of the details throughout this book or in Professional Microsoft SQL Server 2012 Integration Services (Wrox, 2012).

Problem	Quick Solution
Loop over a list of files and load each one.	Tasks Required: Foreach Loop, Data Flow Task Solution: Configure the Foreach Loop to loop over any particular directory of files. You should configure the loop to output to a given variable. Map the given variable to a connection manager by using expressions. You can find more on this in Lesson 43.
Conditionally executing tasks.	Solution: Double-click the precedence constraint and set the Evaluation property to Expression and Constraint. Type the condition that you want to evaluate in the Expression box. When you are using the Expression and Constraint option, both the specified execution result and the expression condition must be satisfied for the next task to execute.
Pass in variables when scheduling or running a package.	Solution: Use the /SET command in the DTExec command line or change the Property tab in the Package Execution Utility ...