Automatic Data Warehouse extraction: use the data conversion Service (DTS) designer in the SQL Server Enterprise Manager to create analysis services to process tasks.

This course aims to achieve
In the SQL Server Enterprise Manager
Data conversion Service (DTS) designer
Create an analysis services processing task
To achieve automatic extraction, conversion, and filling of the data required by the Data Warehouse
-------------------------------
(For details, refer to
Create an analysis services processing task)
This example is as follows:
Mini data warehouse building learning: daily household shopping expenses
====================================
Steps:
1. modify source data
Add related data to datelist and paylist tables.
To verify the Running Effect of DTs
2. Open the data conversion Service (DTS) designer in the Server Enterprise Manager.
Right-click the local package option and choose new package
3. On the "task" menu option bar of the open DTS designer
Select analysis services to process the task
4. In the open analysis services processing task dialog box
Select datelist under the dimension under the Data Warehouse
The reconstruction dimension structure under the processing option is selected by default.
Click OK
The default name is dtstask_dtsolapprocess.task_1.
Of course, you can modify it yourself.
5. Repeat Step 3 and 4, but this time you choose
Paylist under multi-dimensional dataset under Data Warehouse
You can use the same default setting.
(Other Options certainly have their own purposes)
6. Now we have it on the designer screen.
Dtstask_dtsolapprocess.task_1,
Dtstask_dtsolapprocess.task_2
Two DTS tasks,
The next step is to design the workflows for these two tasks.
Click task_1, task_2,
Select the "Success time" option under the workflow menu
The two tasks are connected by a line.
In this example, after the dimension is updated successfully
Then update the multi-dimensional dataset.
7. Save the default DTS package name "new package"
8. Right-click the package
The following menu items are displayed:
"Design package" "execution package" "scheduling package"
Do not elaborate on the functions of each item
To enable the automatic DTS function, select the "scheduling package" option.
Design the scheduling rules you need

After the above steps, we have simply implemented
Use the data conversion Service (DTS) designer in the SQL Server Enterprise Manager
Create an analysis services processing task