The Connection Manager page is available here as
well. After this page is displayed, if you click on the Control Flow tab, you will see
a Data Flow Task added there as well. In fact at this point, you should be seeing an
Execute SQL Task and a Data Flow Task on your Control Flow page. It is as easy to
delete objects, as adding objects by right-clicking the object and choosing to delete it
as shown in the next screenshot where Execute SQL Task can be deleted.
There are several other menu items such as Execute Task, Edit Break Points??¦, Add
Precedence Constraint, etc. All these are useful in the package design.
Chapter 2
[ 41 ]
Event Handlers
The Event Handler page can be displayed by clicking on the Event Handler tab. This
brings up the Event Handler page as shown in the next screenshot. The top object for
this page is the Package itself as shown with the default event, OnError. Of course
there are other event handlers to choose from the drop-down list.
Creating a BI Project for SSIS in Visual Studio 2005
[ 42 ]
A package is not the only object that can raise events. Objects contained in the
package can also raise events. This can be seen by clicking on the drop-down for
Executable in the above screenshot. In the next screenshot, Execute SQL Task, and
Data Flow Task are both executables and have Event handlers associated with them,
with which you can trap events.
Do not skip reading instructions on several of the windows that you will
be using as they give you very specific instructions as to what you may do
on that page.
Pages:
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54