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

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.