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 May 9, 2005

Introduction to MSSQL Server Analysis Services: Process Analysis Services Cubes with DTS - Page 5

By William Pearson

Verification: Execute the DTS Package Containing the New Analysis Services Processing Task

Let's test drive our new DTS package from Enterprise Manager, and ensure that the task we have assembled performs as expected.

1.  Expand the Data Transformation Services folder within the appropriate server, within Enterprise Manager.

2.  Click Local Packages, to display the existing local packages (including our recently created one) in the right pane, as depicted in Illustration 13.

Click for larger image

Illustration 13: The Local Packages Appear

3.  Right-click the package marked ANSYS035_FullyProcessWarehouseCube.

4.  Select Execute Package from the context menu that appears, as shown in Illustration 14.

Illustration 14: Select Execute Package from the Context Menu

The DTS package begins executing, with the Executing Package viewer displaying the execution progress "meter," and listing the ANSYS035_Analysis Services Processing Task that we have placed inside the DTS package as the sole step of the package, as depicted in Illustration 15.

Illustration 15: Execution Progress is Displayed ...

Processing of the task and package completes. The Package Execution Results message box appears, confirming successful package execution, as shown in Illustration 16.

Illustration 16: Successful Completion is Indicated ...

NOTE: Upon notification of a failure here, or within any step of a DTS package, we can display error information about the task involved, by simply double-clicking any task(s) listed in the viewer as having not executed correctly.

5.  Click OK to close the message box.

6.  Click Done to close the Executing Package viewer.

We can, as we noted earlier, string multiple tasks together, as well as provide for notification of completions / failures via e-mail and other ways, from an appropriately assembled DTS package. Moreover, DTS packages can be called from other processes, scheduled and so forth, to allow for automation of much of the essential cube refreshment processes.

7.  Exit Enterprise Manager, when ready.


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

We then performed a practice exercise, discussing various processing options as we prepared to specify full processing of a sample cube within the Analysis Services Processing task. Along the way, we discussed other considerations in taking advantage of the options that the task makes available to us. We saved the task within a DTS package, which we then executed to verify operation of the task. Finally, we mentioned some of the options for using the Services Processing task, in conjunction with other tasks, and particularly in combination with scheduling.

» 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