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