Modifying sample load script

Complete the following steps to modify a sample load script.

Procedure

  1. Edit bcp_load_data_files.bat to update the following variables as needed.
    Variable Name
    Description
    DBSERVER
    SQL server name
    DATABASE
    Database name.
    PARALLELLOAD
    Set as TRUE or FALSE. Session extract tasks containing more than 250,000 sessions should have this set to TRUE.
    JOBNAME
    Typically, this setting does not need to be modified.
    CLEARSCHEMA
    To empty an existing schema before loading it with data, set this value to TRUE.
    STOPONERROR
    When this value is set to TRUE, the Data Extractor stops processing the job if an error is encountered by BCP.
    OVERWRITELOGS
    To overwrite existing bcp log files, set this value to TRUE.
    BULKDIR
    Location of data files.
    SCRIPTDIR
    Location of Discover\DataExtractor\scripts directory.
  2. For this example, set the following values: 
    
set DBSERVER=localhost
set DATABASE=TLWEB
set PARALLELLOAD=FALSE
set JOBNAME=*
set CLEARSCHEMA=TRUE
set STOPONERROR=TRUE
set OVERWRITELOGS=FALSE
set BULKDIR=C:\Discover\DataExtractor\DataFiles
set SCRIPTDIR=C:\Discover\DataExtractor\scripts
  3. Save the file.