Database Reference
In-Depth Information
add a New project to a Current Solution
First, we add a new project to the weatherTrackerProjects solution. The following steps guide you through
this process.
1.
with the weatherTrackerProjects visual Studio solution open, click the solution
'weatherTrackerProjects' icon in Solution Explorer. (The visual Studio menus are
context sensitive, and we want to be working with the solution itself and not any of
the solution folders.)
2.
use the File menu to add a new project to your current visual Studio solution
by clicking File ➤
Add
➤ New Project. (Make sure you do not choose
File ➤ New ➤ Project. The two options are easily confused.) See Figure
2-24
.
3.
when the Add New Project dialog window opens, select the Business
intelligence ➤ integration Services option on left side of this window, and on the
right side, select integration Services Project from the options. See Figure
2-25
.
4.
At the bottom of this dialog window, in the Name textbox, type
WeatherTrackerETL
.
verify that the Location textbox reads C:\_BiSolutions\weatherTrackerProjects. See
Figure
2-25
.
5.
Click OK to close this dialog box.
add an existing SSIS package to the project
Once the weatherTrackerETL project has been created, it appears in your Solution Explorer window. we are
now going to add an existing package to the weatherTrackerETL project.
Select the SSiS Packages folder and right-click the
Package.dtsx
file to access
the context menu. This is similar to Figure
2-26
, but we choose a different option
from the context menu.
1.
2.
we do not need the
Package.dtsx
file, so click the Delete context menu option.
A pop-up message box appears asking whether you are sure you want to
permanently delete this. Click OK to continue.
3.
Now we add a premade
.dtsx
file to the project from the downloadable book files.
Right-click the SSiS Packages folder and select the Add Existing Package option
from the context menu. See Figure
2-40
. The Add a Copy of Existing Package dialog
window appears (Figure
2-41
).
