Database Reference
In-Depth Information
Because each data flow always has a source and destination, you can start outlining one source task and one
destination task. In our example, we need a flat file source and a SQL Server destination (Figure
2-34
).
Figure 2-34.
Outlining the first Data Flow task
When configuring a Data Flow task, it is important to configure the data source first before you configure
the data destination. One common mistake is to outline the process of your data flow by putting a source and
destination task onto the data flow surface and then connecting the tasks immediately. You do not want to
connect the destination until after you have configured the data source. Doing it out of order will automatically,
but improperly, configure the data destination.
Not
■
if you mistakenly edit the destination task before you configure and connect the data source to it, the data
destination becomes corrupt. The simplest way to resolve this is to delete the data destination and replace it with a
new one from the Toolbox. Afterward, configure and connect the data source before you attempt to edit the destina-
tion task.
Configuring Additional Data Flows
Since a single SSIS package can consist of many Data Flow tasks, Microsoft made it easy for you to switch
between them. At the top of the Data Flow tab there is a dropdown box labeled Data Flow Task. You can select
between the individual Data Flow tasks that are part of your SSIS package using this dropdown box (Figure
2-35
).
