SSIS is not supported in SQL Express (http://technet.microsoft.com/en-us/
library/ms165636.aspx).
Creating Your First BI Project for SSIS
In this exercise, you will create a BI project for SSIS with a default package that is
present, and then review the Microsoft Visual Studio IDE to get acquainted with the
various windows that are opened; some of which are specific to SSIS. You will also
review the properties of the default package created with the project.
Launching VS 2005 and Creating a BI Project
for Integration Services
When Visual Studio 2005 is installed, a shortcut will be added to the All Programs,
which is visible when you click on the Start button of your computer. Now launch
the program by clicking on the drop-down menu item, Microsoft Visual
Studio 2005.
Chapter 2
[ 29 ]
You can also launch the same from a menu from the Microsoft SQL Server 2005
shortcut, as shown in the following screenshot.
Microsoft Visual Studio IDE application is launched, showing the Start Page
(as shown in the next screenshot), listing all the installed programs and add-ins.
This window also shows you projects that you have worked on recently under
Recent Projects. It has an empty Solution Explorer window and a bare Properties
window. Solution Explorer is a container to which you can add projects that you
want to create or modify. The links to the various MSDN: SQL Server related
content on the internet is provided by the window next to the Recent Projects
window.
Pages:
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48