Running the Model Builder DTS Task

Article
11/12/2009

You use the Model Builder DTS task to automatically rebuild analysis models. You use the Predictor resource to build analysis models manually before you use the Model Builder task to rebuild models. After you build a model manually by using the Predictor resource, you can use the Model Builder task to schedule automatic rebuilding of the analysis model.

Each time an analysis model is built, it is based on the data currently in the Data Warehouse. It is important to rebuild analysis models when the data in the Data Warehouse changes, such as after new data is imported into the Data Warehouse.

You can use the Model Builder DTS task to rebuild analysis models for a specified site or for all sites associated with a specified Data Warehouse.

Ee785056.note(en-US,CS.20).gif Note

Build one analysis model at a time. If you schedule two or more models to be built simultaneously, the DTS task will fail. To schedule building multiple models, you must schedule them to run one after another.

To rebuild analysis models

Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.
Right-click Data Transformation Services, and then click New Package.

Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. Select the package you want to change, and then click Open.
On the Task menu, click Model Builder (Commerce Server).

In the Model Builder Properties dialog box, do the following:

Use this	To do this
Description	Type a description for this task. The maximum number of characters for the description is 255.
Source type	Select either Site or Data Warehouse from the drop-down list.
Site name	Select the site name from the drop-down list. If you selected Site as the source type, you must select the site for which you want to rebuild an analysis model.
Data Warehouse name	Select the name of the Data Warehouse from the drop-down list. If you selected Data Warehouse as the source type, you must select the Data Warehouse associated with the sites for which you want to rebuild an analysis model.
Model to rebuild	Select an analysis model from the drop-down list.

In the Archive properties section, do the following:

Use this	To do this
Archive current model	Select this check box to archive the analysis model.
Archived model name suffix	Select either Date of rebuild or Version number from the drop-down list.
Archived model name	Type a model name if you want to use anything other than the default name provided.

In the Retry properties section, do the following:

Use this	To do this
Number of retry attempts	Type the number of times (between 0 and 255) you want the Data Warehouse to retry if encountered with erroneous data. The default number of retries is 10.
Time between attempts (seconds)	Type the amount of time in seconds (between 1 and 3600) you want the Data Warehouse to wait before it attempts to retry. The default time-out interval is 30 seconds.

Click OK.
On the Package menu, click Execute.

The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you that it completed successfully.
Click OK, and then click Done.

The specified analysis model is rebuilt with current data from the Data Warehouse.

Running the Model Builder DTS Task

See Also

Additional resources