Adding Connections and Other Tasks to the Package

Analysis Services

Analysis Services

Adding Connections and Other Tasks to the Package

In a Data Transformation Services (DTS) package, you can add connections and tasks of various types in addition to the Analysis Services Processing task. The specific connections and tasks you may need depend on your unique requirements and circumstances. The following table lists some common examples.

If the Analysis Services Processing task ...
You can add ...

That executes ...


Because ...
Processes a cube with the Process option
  • A connection to a Microsoft® SQL Server™ 2000 containing an OLTP database, and

  • A connection to a SQL Server containing a data warehouse, and

  • A Data Driven Query task to update the data warehouse from the OLTP database
Before the Analysis Services Processing task You can schedule and periodically execute the package to automatically update the data warehouse and add current information to the cube.
Processes a cube or partition with the Incremental update option A Microsoft ActiveX® Script task that modifies one or more of the properties of the Analysis Services Processing task. These properties include Datasource, FactTable, and Filter. Before the Analysis Services Processing task A package that is executed repeatedly to perform periodic incremental updates usually requires that one or more of these properties be changed for each execution. For more information, see Changing Properties of an Analysis Services Processing Task.
Processes any object with any option A Send Mail task configured so that the task executes if the preceding task fails After the Analysis Services Processing task An administrator will be notified automatically if the Analysis Services Processing task fails.

Note  In a package, you do not need to add connections to the data sources of databases, cubes, and partitions defined in SQL Server 2000 Analysis Services. The Analysis Services Processing task establishes the required connections.

After you add the connections and tasks, you can organize them into an orderly workflow by adding precedence constraints.

See Also

DTS Overview