Example of a DMS file

This topic provides an example of a Data Management Script (DMS) file, which transfers all of the case data in a UNICOM Intelligence Data File to a IBM SPSS Statistics .sav file. This example demonstrates the minimum contents of a DMS file, which must contain the following sections:

Defines the location and format of the data that you want to transfer. (This example contains only one input data source. However, you can define more than one InputDataSource section in a DMS file when you want to merge data.) See InputDataSource section.

Defines the location and format to which you want to transfer the data. (This example contains only one output data source. However, you can define more than one OutputDataSource section in a DMS file. When you do this, the data will be transferred to each of the specified output data sources.) See OutputDataSource section.

InputDataSource(myInputDataSource)
  ConnectionString = "Provider=mrOleDB.Provider.2; _
    Data Source=mrDataFileDsc; _
    Location=C:\Program Files\UNICOM\Intelligence\<version>
        \DDL\Data\Data Collection File\museum.ddf; _
    Initial Catalog=C:\Program Files\IBM\SPSS\DataCollection\
        <version>\DDL\Data\Data Collection File\museum.mdd"
End InputData

Source OutputDataSource(myOutputDataSource)
  ConnectionString = "Provider=mrOleDB.Provider.2; _
  Data Source=mrSavDsc; _
  Location=C:\Program Files\UNICOM\Intelligence\<version>
      \DDL\Output\Simple.sav"
  MetaDataOutputName = "C:\Program Files\UNICOM\Intelligence\
      <version>\DDL\Output\Simple.mdd"
End OutputDataSource

Logging(myLog)
  Path = "c:\temp"
  Group = "DMGR"
  Alias = "Tester"
  FileSize = 500
End Logging

This example is provided as a sample DMS file (called Simple.dms) in the UNICOM Intelligence Developer Documentation Library. For more information, see Sample DMS files. To run a DMS file, see 1. Running your first transfer.