Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 13, 2006

Process Analysis Services Objects with Integration Services - Page 6

By William Pearson


Execute the Integration Services Package Containing the New Analysis Services Processing Task

Let's test drive our new Integration Services package from within the development environment, and ensure that the task we have assembled performs as expected.

1.  On the Control Flow tab, right click the new ANSYS044_Adventure Works Full_Processing task.

2.  Select Execute Task from the context menu that appears, as depicted in Illustration 27.

Illustration 27: Select Execute Package from the Context Menu

The ANSYS044_Adventure Works Full_Processing task box on the Control Flow tab turns yellow as execution (of the task as well as its parent package, SSIS_Processing.dtsx) begins.

3.  Click the Progress tab (shown in Illustration 28), which appears once execution starts, to monitor the events encountered within the operation of the ANSYS044_Adventure Works Full_Processing task.

Click for larger image

Illustration 28: Access the Progress Tab to Monitor Processing Events

Processing events are logged (we can click on any of these to access amplifying information, if desired) and appear on the Progress tab as partially depicted in Illustration 29.

Illustration 29: Partial View of Events Logged on the Progress Tab

Once processing successfully completes, the ANSYS044_Adventure Works Full_Processing task box turns green on the Control Flow tab.

4.  Click the link below the Connection Managers pane, which tells us "Package execution completed. Click here to switch to design mode, or select Stop Debugging from the Debug menu," as shown in Illustration 30.

Illustration 30: Stop Debugging via the Link Shown Circled Above

We can, as we noted earlier, string multiple tasks together within our package, as well as provide for notification of completions / failures via e-mail and other ways, from an appropriately assembled Integration Services package. Moreover, Integration Services packages can be called from other processes, scheduled and so forth, to allow for automation of much of the essential cube refreshment process. (For more information on the steps required to deploy the project containing our package, see the MSSQL Server 2005 Books Online).

5.  Select File -->Exit to leave the Business Intelligence Development Studio, saving if prompted, when desired.


In this article, we examined the processing of an Analysis Services cube via the Analysis Services Processing task in Integration Services, one of two Analysis Services tasks that accompany the installation of Analysis Services. After introducing this prefabricated Integration Services task, we discussed multiple processing operations that we can use it to perform, at multiple levels of an Analysis Services database structure.

After preparing a project within which to create an Integration Services package, we began a practice exercise, adding the Analysis Services Processing task, and then a Connection Manager, to the package. We discussed various processing options as we configured our Analysis Services task to specify full processing of a sample cube. Along the way, we discussed other considerations in taking advantage of the options that the task makes available to us. Finally, we executed the Integration Services package containing our Analysis Services Processing task to verify its operation.

» See All Articles by Columnist William E. Pearson, III

Discuss this article in the MSSQL Server 2000 Analysis Services and MDX Topics Forum.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM