When the project is created for the first time, this
window is populated by a tree view showing the various items created, as shown
below. You can use this drop-down menu to bring in an existing package, a New
Item or an Existing Item. There is a lot of flexibility built into this IDE. You can also
Build, Rebuild, or Clean the project.
Chapter 2
[ 49 ]
If you choose the Existing Package option, this is what will be displayed. Packages
can be saved to any one of the three places, although the VS 2005 IDE saves the
package to a folder. The window that opens up is now going to look into those
places as shown. Of course packages have ownership and you need to get properly
authenticated; and you should have the permissions to work with the package. You
can also browse to discover the path where you have saved the package.
Creating a BI Project for SSIS in Visual Studio 2005
[ 50 ]
On the other hand if you had chosen New Item??¦, you would open up a different
window. You can add any of the items shown that include a new SSIS package.
Data Source when selected will bring up its own wizard which will guide you to
add a new data source. Similarly, selecting Data Source View, will bring up its
wizard which will guide you to create a Data Source View, which you can add
to your project. The wizard is a macro, built for user a interface that helps in the
configuration of these objects.
As mentioned previously, it is important to look out for contextual help.
Pages:
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57