Scripting the Product Catalog Import DTS Task
The following script creates and runs the Product Catalog Import DTS task. This script can be used to create a package containing the DTS task to be run. The sample script can be run in two different ways. You can run the package on the command line by using the command DTSRun.exe. The file DTSRun.exe is automatically installed on your server when you install SQL Server. Or you can copy the script into a Visual Basic script file (.vbs) and run it by using cscript, for example, <drive>:cscript <filename>.vbs.
To successfully complete the import of data into the Data Warehouse, run the DTS tasks in the following order:
- Configuration Synchronization
- Web Server Log Import
- Transaction Data Import
- Product Catalog Import
- Profile Data Import
- Campaign Data Import
- Data Deletion
- Model Builder
- IP Resolution
- Report Preparation
- Report caching
For more information about the DTSCatalogImport object, see DTSCatalogImport Object.
For a description of this DTS task, see Commerce Server DTS Tasks.
'******************************************************************
' Catalog Data Import DTS Task
' This script creates a DTS package and runs it.
'******************************************************************
Dim oPackage
Dim oTask
Dim oStep
Dim oProps
Dim oTaskProps
Dim DTSStepExecResult_Failure
Dim iStatus
Dim i
DTSStepExecResult_Failure = 1
'On Error GoTo PackageError:
set oPackage = WScript.CreateOBject("DTS.Package")
'******************************************************************
' Define package properties.
'******************************************************************
oPackage.Name = "Catalog Import DTS Task "
oPackage.Description = "Imports catalog data."
'******************************************************************
' Create a task.
'******************************************************************
Set oTask = oPackage.Tasks.New("Commerce.DTSCatalogImport")
oTask.Name = "Task1"
oTask.Description = "Creates a task for ProductCatalogImport DTS"
Set oTaskProps = oTask.Properties
' Set Catalog DTS properties
' Incremental import = 100
' Full Import= 0
oTaskProps("ProcessingType").value = 0
' 0 for the site level import and 1 for the Data Warehouse level import
oTaskProps("SourceType").value = 0
'You can either import at the site level or the Data Warehouse level
oTaskProps("SourceName").value = "BlankSite"
' Number of SQL Server retries in case of SQL Server failure
oTaskProps("NumRetries").value = 0
oTaskProps("RetryInterval").value = 20
'**********************************************************************
' Set the catalog dimensions you want to import
'**********************************************************************
oPackage.Tasks.Add oTask
'******************************************************************
' Create a step.
'******************************************************************
Set oStep = oPackage.Steps.New
oStep.Name = "Step1"
oStep.TaskName = "Task1"
'For custom tasks written in Visual Basic, the steps cannot run on a
' secondary thread.
oStep.ExecuteInMainThread = True
oPackage.Steps.Add oStep
'******************************************************************
' Execute the package.
'******************************************************************
oPackage.Execute
For I = 1 To oPackage.Steps.Count
If oPackage.Steps(I).ExecutionResult = 1 Then
iStatus = False
MsgBox oPackage.Steps(I).Name + " in the " + _
oPackage.Name + " failed."
End If
Next
MsgBox oPackage.Name + " Done"
Set oStep = Nothing
Set oTaskProps = Nothing
Set oProps = Nothing
Set oTaskProps = Nothing
Set oPackage = Nothing
Copyright © 2005 Microsoft Corporation.
All rights reserved.