Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services

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?" This table shows you common problems you're going to want to solve in SSIS and a quick solution on how to solve it. These solutions are just crib notes and most of the details can be found throughout the book or in Professional Microsoft SQL Server 2008 Integration Services (Wrox, 2008).

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. The loop should be configured to output to a given variable. Map the given variable to a connection manager by using expressions. More of this can be found in Lesson 33.
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.
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 to have the property path like \Package.Variables[User::VariableName].Properties[Value]. More on this can be seen in Lesson 45.
Move and rename the file at the same time	Tasks Required: File System ...