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.
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.