You will see all the
log providers discussed in Chapter 1 here.
Just below the Solution Explorer window, you will find the Properties window,
where a wealth of information regarding the package is displayed. The Identification
property is shown expanded in the window. The package name, the creator name,
the created date, etc. are all documented here. Expand other properties and get
acquainted with the information. Security is obviously one thing you may want to
look up and, if needed, set up a password for the package.
Chapter 2
[ 37 ]
Canvas for Package Design
The Canvas for package design is shown wedged inbetween the Toolbox and the
Solution Explorer, as shown in an earlier screenshot. The following screenshot
shows this Canvas, consisting of four tabbed pages at the top??”Control Flow, Data
Flow, Event Handlers, Package Explorer, and the Connection Managers tab at
the bottom.
Creating a BI Project for SSIS in Visual Studio 2005
[ 38 ]
Control Flow
Control Flow items group will be displayed when you choose the Control Flow
tabbed page. You can drag items from Control Flow, as well as Maintenance Plan
Tasks toolbox groups to this page. For example an Execute SQL Task has been
dragged to the Control Flow page in the previous screenshot. (You can doubleclick
on an item in the toolbox and add the item to Control Flow also.) This object
has a red circle with a white cross. This indicates that the object's configuration is
incomplete.
Pages:
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52