Processing Objects Using Data Transformation Services

Processing Objects Using Data Transformation Services

Use the Analysis Services Processing task in a Data Transformation Services (DTS) package to perform processing of one or more cubes or other objects defined in Microsoft® SQL Server™ 2000 Analysis Services. Use DTS to extract, transform, and consolidate data from disparate sources into single or multiple destinations. For more information about using DTS with Analysis Services, see Using Data Transformation Services with Analysis Services. For more information about DTS, see DTS Overview.

After you define the package with the task, you can schedule the package to execute at a future date and time. The package can be executed once or repeatedly at a periodic interval.

Note  To use the Analysis Services Processing task, you must install SQL Server 7.0 or SQL Server 2000, including SQL Server Enterprise Manager, as well as Analysis Manager on the server computer on which you want to execute the package containing the task.

To process one or more objects using the Analysis Services Processing task, complete the following steps.

1. Create a DTS package that processes objects in Analysis Services.
   1. Create an Analysis Services processing task.
      
      
   2. (Optional.) Add connections and other tasks to the package.
      
      
   3. Save the package.
2. Schedule and execute the package.

For more information about steps a and b, see Creating an Analysis Services Processing Task and Adding Connections and Other Tasks to the Package.