Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Solving Common SSIS Scenarios

As you work with SSIS, you may realize that certain tasks become commonplace. You may find

yourself implementing the same solution over and over again, for example, moving data from

one database to another. You would typically do this by using the data flow, as in Figure 7-1.

FIGURE 71

In Figure 7-1 you see a data flow source that will extract data from some source. The data flow

source is connected to a data flow destination, which is where the data will be exported. You

may place some data flow transformations between the source and destination, but ultimately

the goal is the same, moving data from one data source to another.

You may also encounter a situation in which you need to import data from multiple text files

into one single destination. You would typically do this by using a Foreach Loop container on

the control flow, as in Figure 7-2.

7

889633c07.indd 59 8/16/10 9:13:36 PM

60



LESSON 7 Solving Common SSiS SCenarioS

FIGURE 72

As you can see in Figure 7-2, the Foreach Loop container contains a Data Flow task that will handle the

movement of the data from the text file to the destination. Double-click the Foreach Loop container to

open the Foreach Loop Editor, shown in Figure 7-3.

FIGURE 73

889633c07.indd 60 8/16/10 9:13:36 PM

Solving Common SSiS SCenar ...