How to Run the Profile Data Import DTS Task

  • Article

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

You use the Profile data import Data Transformation Services (DTS) task to import profile data that is collected on the Web site into the Data Warehouse.

When you import profile data into the Data Warehouse, the Profile data import DTS task extends the schema of the Data Warehouse to create any new profile definition properties marked as exported.

Note

If you are using SQL Server 2005, you must install DTS 2000 Designer and run the Data Warehouse Import Wizard to create a package. You must have already created a package using the Data Warehouse Import Wizard or have existing packages to import before you can perform this task.

To run the Profile data import DTS task

  1. Run the Configuration synchronization DTS task to synchronize your site configuration with the Data Warehouse. For instructions, see How to Run the Configuration Synchronization DTS Task.

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

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

  4. In the DTS Package or DTS 2000 Package Designer dialog box, on the Task menu, click Profile Data import (Commerce Server).

  5. In the Profile Import Properties dialog box, do the following:

    Use this

    To do this

    Description

    Type a description for the import task.

    Operation level

    Select Data Warehouse level from the drop-down list.

    Site name

    Select from the drop-down list the Data Warehouse associated with the site for which you want to import profile data.

    Query interval (mins.)

    Type the time interval for the import. The default interval is 15 minutes. The query interval begins at the import start date. New and updated user data is imported in time intervals to prevent locking the database table. For example, a Web site that has 10,000 users would import user data in 15-minute intervals.

    Setting a smaller value will lock the table for a shorter duration but will increase the number of queries against the table and therefore the time that the task takes to run. Setting the value to zero will run a single query, locking the table for the duration of import but may decrease site performance.

    Import start date

    Select from the drop-down calendar a date on which to start your import.

    Incremental load

    Select this option to import only new users (based on a previous import).

    Full load

    Select this option to import all user data.

  6. 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 time in seconds that you want the task to wait between retry attempts. The default time interval is 30 seconds.

  7. In the Profile Import Properties dialog box, click OK.

  8. On the Package menu, click Execute.

Note

Clicking Execute on the Package menu will execute all tasks associated with the selected package. If you want to execute a specific task, for example the profile data import task, right-click Profile Data import (Commerce Server), and then click Execute Step.

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

See Also

Other Resources

How to Run the Report Preparation DTS Task

How to Run the Configuration Synchronization DTS Task

Running the DTS Tasks

Importing Data into the Data Warehouse

Managing the Data Warehouse

Commerce Server Operations