Share via


Transaction Import Properties Dialog Box

Use the Transaction Import Properties dialog box to specify the sites whose log file transaction data you want to import into the Data Warehouse by using the Transaction Data Import DTS task. Commerce Server generates transaction data on your Web site when a user adds and removes items from a shopping cart, or makes a purchase. After you import this data, you can run reports to analyze the data.

Use this

To do this

Description

Type a description for the DTS task. The maximum number of characters for the description is 255 characters.

Operation level

From the drop-down list, select an operation level:

  • Site level. Import log files for the specified site only.

  • Data Warehouse level. Import log files for all sites in the Data Warehouse.

Site name

From the drop-down list, select the site that contains the data that you want to import.

Data Warehouse name

From the drop-down list, select the Data Warehouse associated with the sites that contain the data that you want to import.

Incremental load

Select to only import new transaction data generated since the last time that you ran the import process.

Full load

Select to import all transaction data in the log file.

Query interval

Type the time interval for the import. Commerce Server imports user data 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 the task takes to run. Setting the value to zero will run a single query, locking the table for the whole duration of import but may decrease site performance.

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

Seconds between retries

Type the number of seconds you want the task to wait between retry attempts. The default time interval is 30 seconds.

See Also

Other Resources

ETL Process for the Transaction Data Import DTS Task

How to Run the Transaction Data Import DTS Task

How to Specify the Location of a Log File to the Data Warehouse

Importing Data into the Data Warehouse