Contents

in:
  type: file
  path_prefix: '/sqlserver/data/test1/test1.csv'
  parser:
    charset: UTF-8
    newline: CRLF
    type: csv
    delimiter: ','
    quote: ''
    columns:
    - {name: ID, type: string}
    - {name: TINYINT_ITEM, type: long}
    - {name: SMALLINT_ITEM, type: long}
    - {name: INT_ITEM, type: long}
    - {name: BIGINT_ITEM, type: long}
    - {name: BIT_ITEM, type: boolean}
    - {name: DECIMAL_ITEM, type: string}
    - {name: NUMERIC_ITEM, type: string}
    - {name: SMALLMONEY_ITEM, type: string}
    - {name: MONEY_ITEM, type: string}
    - {name: REAL_ITEM, type: double}
    - {name: FLOAT_ITEM, type: double}
    - {name: CHAR_ITEM, type: string}
    - {name: VARCHAR_ITEM, type: string}
    - {name: TEXT_ITEM, type: string}
    - {name: NCHAR_ITEM, type: string}
    - {name: NVARCHAR_ITEM, type: string}
    - {name: NTEXT_ITEM, type: string}
    - {name: DATE_ITEM, type: timestamp, format: '%Y/%m/%d'}
    - {name: DATETIME_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: DATETIME2_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: DATETIME2_2_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S.%N'}
    - {name: SMALLDATETIME_ITEM, type: timestamp, format: '%Y/%m/%d %H:%M:%S'}
    - {name: TIME_ITEM, type: timestamp, format: '%H:%M:%S.%N'}
    - {name: TIME_2_ITEM, type: timestamp, format: '%H:%M:%S.%N'}
out:
    type: sqlserver
    host: #host#
    database: #database#
    user: #user#
    password: #password#
    table: TEST1
    mode: insert_direct

Version data entries

22 entries across 11 versions & 1 rubygems

Version	Path
embulk-output-sqlserver-0.7.10	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.10	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.9	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.9	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.8	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.8	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.7	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.7	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.6	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.6	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.5	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.5	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.4	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.4	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.3	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.3	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.2	src/test/resources/sqlserver/yml/test-jtds.yml
embulk-output-sqlserver-0.7.2	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.1	src/test/resources/sqlserver/yml/test-insert-direct.yml
embulk-output-sqlserver-0.7.1	src/test/resources/sqlserver/yml/test-jtds.yml