Chapter 2
[ 43 ]
Package Explorer
Click on the Package Explorer tab to reveal everything that pertains to the package,
as shown below.
Creating a BI Project for SSIS in Visual Studio 2005
[ 44 ]
This shows the complete details of the package. It shows two tasks, Execute SQL
Task and Data Flow Task, and as these may execute in a given order there is a
folder for Precedence Constraint which executes first. Data Flow Task is going to
have other components, and therefore there is a folder for components. Each of these
executables can have their own variables including the package. There are event
handlers with each of these executables.
The Toolbox
If you are on the Control Flow page of the canvas, you will see Control Flow Items
and Maintenance Plan Tasks. On the other hand, if you are on Data Flow page, you
will see items related to Data Flow Sources, Data Flow Transformations, and Data
Flow Destinations. When you are on either Event Handlers or Package Explorer,
you will see Control Flow items and Maintenance Plan items.
Adding Items not Available in the Toolbox
In a default installation, all the components of the toolbox will be present. These
were described in Chapter 1. Should you find any missing for any reason you can
add it to the toolbox, as explained in this section.
The toolbox has a drop-down menu associated with it, shown in the next screenshot.
This will be displayed when you right-click anywhere in the toolbox.
Pages:
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55