How to Run the Transaction Data Import DTS Task

  • Article

You use the Transaction data import Data Transformation Services (DTS) task to import site transaction data into the Data Warehouse. You store transaction data in the Commerce Server transaction database. It includes purchase orders and requisition numbers that you use to analyze reports to determine how well individual products are selling, how much is being requisitioned, or how much your customers are purchasing.

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 Transaction 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. In the DTS Package or DTS 2000 Package Designer dialog box, on the Task menu, click Transaction data import (Commerce Server).

  4. In the Transaction Import Properties dialog box, do the following:

    Use this

    To do this

    Description

    Type a description for the import task.

    Operation level

    Select Site level from the drop-down list.

    Site name

    Select from the drop-down list the site that contains the data that you want to import.

    Query interval (mins.)

    Type the import interval in minutes. A value of zero (0) will issue a single query against the SQL Server source tables. This can potentially result in locking the tables. For any value greater than zero (0), the task will incrementally import the transactions in groups as determined by the query interval value. For example, if the query interval is 25 minutes (the default value) and the first transaction was logged at 1:30A.M., the transaction data import task imports all transactions logged between 1:30A.M and 1:55A.M.. Then it would import transactions between 1:55A.M. and 2:20A.M.. This pattern continues until the current time is reached, then the task stops.

    If the transaction database is in a different time zone than the Data Warehouse, the import will stop at the current time of the import, when it is converted into the time zone of the transaction database. For example, if the transaction database is in the EST time zone, and the Data Warehouse is in the PST time zone, and the current time is 8:00A.M. in PST, the import will stop when the query interval reaches 8:00A.M. in EST.

    Incremental load

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

    Full load

    Select this option to import all transaction data.

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

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

  7. 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 transaction data import task, right-click Transaction data import (Commerce Server), and then click Execute Step.

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

  8. In the Package Execution Results dialog box informing you that it completed successfully, click OK.

  9. In the Executing Package dialog box, click Done.

    Transaction data is imported into the Data Warehouse.

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