Professional > Data management scripting > Transferring data using a DMS file > Reading data > Transferring data from log files
 
Transferring data from log files
You can transfer data from a UNICOM Intelligence log file using Log DSC.
How do I specify reading from a UNICOM Intelligence log file?
In the connection string in the InputDataSource section, specify mrLogDsc for the Data Source and MR Init MDSC connection properties. Specify the name and location of the log file for the Location and Initial Catalog connection properties. In UNICOM Intelligence Data Model 2.7 and later, you can specify the location of a folder to include all of the log files in that folder:
InputDatasource(myInputDataSource, "My input data source")
  ConnectionString = "Provider=mrOleDB.Provider.2; _
    Data Source=mrLogDsc; _
    Location=<Name and location of the log file or log file        folder>; _
    Initial Catalog=<Name and location of log file>; _
    MR Init MDSC=mrLogDsc"
End InputDatasource
Example
This example transfers the MDG335.tmp log file to a UNICOM Intelligence Data File (.ddf), using the DDFOutput.dms Include file.
InputDataSource(myInputDataSource, "My input data source")
ConnectionString = "Provider=mrOleDB.Provider.2; _
Data Source=mrLogDsc; _
Location=C:\Temp\DMG33Z.tmp; _
Initial Catalog=C:\Temp\DMG33Z.tmp; _
MR Init MDSC=mrLogDsc"
End InputDataSource

#define TargetDDF "C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Output\LogToDDF.ddf"
#define TargetMdd "C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Output\LogToDDF.mdd"
#Include "C:\Program Files\IBM\SPSS\DataCollection\7\DDL\Scripts\Data Management\DMS\Include\DDFOutput.dms"
The UNICOM Intelligence Developer Documentation Library comes with a sample Include file (called LogInput.dms) that you can use to define a transfer from a UNICOM Intelligence log file.
See also
Transferring data using a DMS file
Reading data