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).
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 ...