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:
InputDataSource
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.
OutputDataSource
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.
Example file
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
It is recommended that you also include a
Logging section in your DMS file. This means that details of any problems are written to a log file, which is useful when trying to track down the cause of any problems that occur.
Logging(myLog)
Path = "c:\temp"
Group = "DMGR"
Alias = "Tester"
FileSize = 500
End Logging
See also