They are all accessible if your solution adds other project types to the solution.
The Start Page sub-menu item takes you to the Start Page which appeared when the
application was launched, while the Web browser sub-menu item takes you to the
Microsoft Web site http://www.microsoft.com/sql/default.mspx for
SQL Server.
Debug Windows
Debug windows are not accessible from the View menu. When the package is
executed, and the program is in the debug mode, you can see all sub-menu items
of the Debug menu. While the program is running in debug mode, you will not be
allowed to remove objects or close the design windows. There are several important
windows used in debugging??”Breakpoints, Watch, Locals, and Call Stack.
Creating a BI Project for SSIS in Visual Studio 2005
[ 66 ]
In the Ch 2 project, Execute SQL Task does not have a connection manager, and
if you try to execute the package, you immediately get an error like that shown
below. In this scenario you will not be able to access any of the debugging windows.
You can test this by deleting Execute SQL Task. Click on Build to build a project
and execute it. After doing this, you can access all the sub-menus of the debugging
window from the Debug menu.
BI Related Items in Tools/Options
There are a couple of items related to SSIS designer in the Options sub-menu of the
Tools main menu. These options can be used to configure the designer such that
when a new item is added to either the Control Flow page or the Data Flow page,
the existing items get connected to the added items automatically.
Pages:
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64