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: string}
    - {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: string}
    - {name: TIME_2_ITEM, type: timestamp, format: '%H:%M:%S.%N'}
out:
    type: sqlserver
    host: localhost
    database: TESTDB
    user: TEST_USER
    password: test_pw
    table: TEST1
    mode: insert_direct
    column_options:
      DATETIME2_ITEM: {value_type: pass}
      TIME_ITEM: {value_type: pass}

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
embulk-output-sqlserver-0.6.5	src/test/resources/sqlserver/yml/test-string-timestamp.yml
embulk-output-sqlserver-0.6.4	src/test/resources/sqlserver/yml/test-string-timestamp.yml
embulk-output-sqlserver-0.6.3	src/test/resources/sqlserver/yml/test-string-timestamp.yml
embulk-output-sqlserver-0.6.2	src/test/resources/sqlserver/yml/test-string-timestamp.yml
embulk-output-sqlserver-0.6.1	src/test/resources/sqlserver/yml/test-string-timestamp.yml
embulk-output-sqlserver-0.6.0	src/test/resources/sqlserver/yml/test-string-timestamp.yml
embulk-output-sqlserver-0.5.1	src/test/resources/sqlserver/yml/test-string-timestamp.yml
embulk-output-sqlserver-0.5.0	src/test/resources/sqlserver/yml/test-string-timestamp.yml