How to Run the Configuration Synchronization DTS Task

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

You use the Configuration synchronization DTS task to import the site configuration data that is stored in the Administration database into the Data Warehouse. This differs from the Synchronize Values button in the Application Properties dialog box. When you click the Synchronize Values button, Commerce Server reads the values from the Internet Information Services (IIS) metabase to the Administration database, and then from the Administration database to the Data Warehouse. For more information, see How to Configure an Application.

In addition to running the Configuration synchronization DTS task to import site configuration data into the Data Warehouse, you perform the same step when you do either of the following:

• Configure the Data Warehouse resource

• Unpack a site

The Data Warehouse stores the site configuration data. This includes site topology settings, instead of reading it from the Administration database.

You can synchronize the Data Warehouse with a single site, or with all of your sites. You must run the synchronize task before you run any import or delete tasks. You cannot cancel this task after it is started.

To run the configuration synchronization DTS task

1. If you are using SQL Server 2005, do the following:

   1. Click Start, point to Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.

   2. In SQL Server Management Studio, in the Object Explorer pane, expand the server on which your Data Warehouse is installed, expand Management, and then expand Legacy.

   3. Right-click the package that contains the task that you want to run, and then click Open.

      If the package that you want to open is not in the list, right-click Data Transformation Services, and then click Open Package File or Import Package File. In the Open DTS 2000 Package or Import DTS 2000 Package dialog box, click the package that you have previously saved and want to open or import, and then click Open.

2. If you are using SQL Server 2000, do the following:

   1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

   2. In the SQL Server Enterprise Manager console, in the left pane, expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.

   3. Right-click Data Transformation Services, and then click New Package.

      Alternatively, if you are changing an existing package, right-click Data Transformation Services, and then click Open Package. In the Select File dialog box, click the package you want to change, and then click Open.

3. In the DTS Package or DTS 2000 Package Designer window, on the Task menu, click Configuration synchronization (Commerce Server).

4. In the Synchronize DW Properties dialog box, do the following:

   Use this	To do this
   Description	Type a description for the synchronize task.
   Operation level	Select Site level from the drop-down list to synchronize a site together with the Data Warehouse. Or, select Data Warehouse level to synchronize all sites together with the Data Warehouse.
   Site	Select the site that you want to synchronize with the Data Warehouse from the drop-down list.

5. In the Retry Properties section, do the following:

   Use this	To do this
   Number of retries	Type the number of times you want the task to retry connection failures to the Data Warehouse. The default number of retry attempts is 10.
   Seconds between retries	Type the period of time that you want the task to wait between retry attempts. The default time interval is 30 seconds.

6. In the Synchronize DW Properties dialog box, click OK.

7. On the Package menu, click Execute.

The Executing Package dialog box appears that displays the progress of the synchronization.

See Also

Other Resources

Running the DTS Tasks

Importing Data into the Data Warehouse

Managing the Data Warehouse

Commerce Server Operations