Database Reference
In-Depth Information
Figure 7-24.
The SSIS package at the end of Exercise 7-2
in this exercise, you began configuring your ssis package by outlining the various steps required utilizing
sequence containers and ssis tasks. Currently these tasks do not do anything because they have not been
fully configured. in addition, the package will not work until you create one or more connections to the
source and destination objects. we look at how this is done in the next section.
Data Connections
After you have outlined your ETL process on the Control Flow tab, the next step is to create connections so
that you can configure each task. Creating connections is easy; all you have to do is go down to the bottom of
the screen, find the Connection Managers tray, and add a connection by right-clicking the background of the
Connection Managers surface area and selecting New Connection from the context menu (Figure
7-25
). This
action brings up the Add SSIS Connection Manager dialog. From this dialog, you are able to select from several
connection managers.
