Dacris.Maestro.Data.ReadCsvFile Interaction

Reads a CSV file into an in-memory SQL table.

Sample State.json Input

{
  "sampleKey": {
    "connPath": "$.yourStateKey",
    "timeout": "10",
    "inputFile": "folder1/folder2/yourFile.txt",
    "inputPath": "$.yourStateKey",
    "schemaPath": "$.yourStateKey",
    "separator": "yourText",
    "tableName": "yourText",
    "createTable": "False",
    "retryTimes": "10",
    "retryDelay": "10"
  },
  "dataConnections": {
    "your_connName": {
      "systemType": "MemorySql|SqlServer|Firebird|Postgres|MySQL|MockData|CustomValue",
      "connString": ""
    }
  },
  "customDataProviders": {
    "your_systemType": "yourText"
  }
}