Integration Services - Professional SQL Server Analysis Services 2005 with MDX - page 842

4. All the tasks and transforms provided by SSIS are represented within
the toolbox window. To see the toolbox window, click View Toolbox
in the drop-down menu . The toolbox window can be docked by click-
ing the pin icon as shown in Figure 16-2 . Drag and drop the SQL
Server Analysis Services Execute DDL task to the Control Flow tab.
You will now see the task in the window as shown in Figure 16-2 .
The SSIS designer in BIDS completes a validation on every task and
transform in your package. Each task has a certain set of required
properties and some optional properties. If the required properties
are not specified, you will see a red "x" mark within the task. If the
optional properties are not defined you will see a yellow "x" mark
within the task. If any of the tasks or transforms within your package
have a red "x" mark, that indicates that there is an error in your pack-
age and you will not be able to run the package without resolving the
error. The Execute DDL task needs the connection details to Analys-
is Services and the DDL to execute. Because these properties have
not been defined when you drag and drop the task in your editor, you
will see a red "x" mark as shown in Figure 16-2 .
Figure 16-2
5. One of the properties for the Execute DDL task is to specify the con-
nection details to an Analysis Services database. To create a con-
nection to the Analysis Services 2005 Tutorial database, rightclick
the Connection Managers window. You can see all the various types
of connections SSIS supports as shown in Figure 16-3 . Select "New
Analysis Services Connection…"