dtsx and three other folders, Data Sources, Data Source Views, and
Miscellaneous are added to the Solution Explorer window, as shown in the next
screenshot. The default package is empty when created with the name, Package.
It can be renamed to a chosen name, usually descriptive of its intended purpose.
During package design, you can drag and drop appropriate objects from Control
Flow Items, Maintenance Plan Items, and Data Flow Items (Data Source, Data Flow
Transforms, and Data Destination) windows in the toolbox. The design window
of the package is shown wedged in Toolbox and Solution Explorer in the next
screenshot. It is in this window that most of the design is carried out.
Creating a BI Project for SSIS in Visual Studio 2005
[ 34 ]
Chapter 2
[ 35 ]
You may also notice a new menu item, SSIS, added to the main menu. The
sub-menu items of this menu are contextual. This menu item has the following
sub-menu, and you get it to display as shown, provided you first clicked on the
Package Designer pane.
The same menu can also be displayed with some additional items by right-clicking
on an empty area in the Package Designer's Control Flow tabbed page. This is also
contextual and will be displayed when you click on the Control Flow tabbed
page first.
Creating a BI Project for SSIS in Visual Studio 2005
[ 36 ]
These sub-menu items are important in the package design. For example when you
click on the sub-menu item, Logging??¦, you open up the window shown in the next
screenshot that allows you to add a log provider to your package.
Pages:
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51