Let's get some
hands-on practice with a basic Analysis Services Processing task. To
prepare, we will create a new Integration Services project, and, simultaneously,
a new Integration Services package, to which we will add our Analysis
Services Processing task, and within which we will both configure and
execute the task. We will accomplish the steps of our practice
session within the SQL Server Business Intelligence Development Studio.
Create an Integration Services Package within the SQL Server Business Intelligence
begin, we will launch the SQL Server Business Intelligence Development Studio.
and click, the SQL
Server Business Intelligence Development Studio, as appropriate.
equivalent on my server appears as depicted in Illustration 1.
briefly see a splash page that lists the components installed on the PC, and
then Visual Studio .NET 2005 opens at the Start page.
Close the Start
page, if desired.
--> New from the main menu.
... from the cascading menu, as shown in Illustration 2.
Project dialog appears.
Select Business Intelligence
Projects (the default) in the Project types pane of the dialog, if
Services Project, a Visual Studio installed template, within the Templates
pane of the dialog.
In the Name
box of the dialog, type the following name:
provide a path for the new project within the Location box.
Leave the Solution
box at its default (ANSYS044_SSAS_Processing).
remaining settings of the dialog at default.
The New Project
dialog appears, with our settings, similar to that depicted in Illustration
Illustration 3: The New
Project Dialog, with Our Settings
Click OK to
create the project.
new Integration Services project appears in Solution Explorer, as
shown in Illustration 4.
Illustration 4: The
Project Appears within BI Development Studio Solution Explorer
now prepared to add the Analysis Services Processing task to the package
that has been automatically created within our new project. We will do
so in the section that follows.