Chapter 2
[ 45 ]
Creating a BI Project for SSIS in Visual Studio 2005
[ 46 ]
You can customize the toolbox using the drop-down menu items such as Move Up,
Move Down, Sort, etc. If an item is not available, you can click on Choose Items??¦,
which will bring up a whole lot of objects that you can add as shown. All you need
to do is place a check mark and click on Add. You may need to scroll up and down
to locate the required object. If you are planning to add other items to your solution,
you may choose to add .NET Framework Components as well. The IDE is well
suited to cater to a variety of projects.
Chapter 2
[ 47 ]
Toolbox Items
The toolbox consists of items related to control flow, data flow, etc. Control Flow
Items consists of containers and tasks, Data Flow Components consists of sources,
transformations, and destinations. This window is available in the context of the
Control Flow page. The tasks shown here are the usual tasks undertaken by a 'DBA'.
As tasks are related to a database, you generally need a connection manager to point
to the database on a server.
Creating a BI Project for SSIS in Visual Studio 2005
[ 48 ]
The Solution Explorer
As the name suggests, the Solution Explorer window shows every project that is a
part of the solution. You can add other projects, like an Analysis Services project, a
Report Services project, etc. The Solution Explorer is a feature-rich interface with
many menus tucked inside it.
Pages:
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56