Directly below the Control Flow tab on the same page is the tabbed page
(tray), Connection Managers. The connection manager used by the control flow
tasks will be placed here. Again the instruction is clear, to add a connection manager,
right-click and add by choosing the correct drop-down menu item. When you
right-click in the tray, you will display the following menu:
Each of these menu items would open up windows where you can set up the
connection used by Source, Destination, and sometimes Data Flow transformation.
If the type of connection you are planning is not on the menu list, you can click on
New Connection??¦ and configure your desired connection. In this chapter, we will
not be using the Connection Manager.
Chapter 2
[ 39 ]
Data Flow
Clicking on the Data Flow tab will take you to the Data Flow page, as shown in the
following screenshot.
You may click on "No Data Flow tasks have been added to this package. Click here
to add a new Data Flow task." to add a Data Flow task. The page changes to this:
Creating a BI Project for SSIS in Visual Studio 2005
[ 40 ]
Read the instructions for building a Data Flow, given on this page. Data needs to
flow from a source to a destination after going through the transformations stage. By
double-clicking on Data Flow items in the toolbox, you can add items to this page.
Once the objects are added, you can edit their properties by right-clicking on the
object, and then clicking on Edit.
Pages:
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53