O'Reilly logo

Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services by Mike Davis, Devin Knight, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required