Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

19.2. Creating Integration Services Packages for Analysis Services Operations

Using Integration Services is convenient and improves administration productivity by executing administrative tasks on a periodic basis on Analysis Services. Integration Services provides several tasks and transforms that are specifically designed for integration with Analysis Services to help you in building packages in the Business Intelligence Development Studio (BIDS) you have been working with in Analysis Services 2008.

19.2.1. The Execute DDL Task

The Execute DDL task is used for sending a DDL script to Analysis Services. This task is typically used to accomplish administrative tasks like backup, restore, or sync operations that need to be performed on a periodic basis. You can also use this task to send process statements to Analysis Services for processing Analysis Services objects or include this task along with other Integration Services tasks to create a more generalized package; for example, dynamically creating a new partition in a cube by analyzing the fact data — and then processing that partition. To create a package that will backup your Analysis Services database on a periodic basis, do the following:

1. Open BIDS and load the AnalysisServices2008Tutorial project sample available for download on this book's web site at www.wrox.com.

2. Once you have loaded it, go ahead and deploy the project. This specific project has some additions to the ones you have created earlier, so make sure the full ...