in:
  type: file
  path_prefix: '/sqlserver/data/test5/test5.csv'
  parser:
    charset: UTF-8
    newline: CRLF
    type: csv
    delimiter: ','
    quote: ''
    columns:
    - {name: ITEM1, type: timestamp, format: '%Y/%m/%d'}
    - {name: ITEM2, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
    - {name: ITEM3, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: ITEM4, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: ITEM5, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: ITEM6, type: timestamp, format: '%H:%M:%S.%N'}
    - {name: ITEM7, type: timestamp, format: '%H:%M:%S.%N'}
out:
    type: sqlserver
    host: #host#
    database: #database#
    user: #user#
    password: #password#
    table: TEST5
    mode: insert_direct
    insert_method: native