'odbc misinterpreting data types
I am trying to use the odbc driver to transfer data from a sql 2014 table to a snowflake table using SSIS. Both tables have an identical structure.
I have a MD5 columns defined as VARCHAR(32) and datetime columns defined as TIMESTAMP_NTZ(9).
The driver returns a vague error : [Snowflake][Support] (40465) String data truncated while performing conversion. when trying to map all columns.
if i try to map a datetime column, which was converted to a varchar in my source query, the driver returns: state: '22018'. Native Error Code: 100038. Numeric value '2021-09-07 22:36:20.743' is not recognized
when i try to map a single varchar(32) column, the driver returns: state: '22018'. Native Error Code: 100038. Numeric value 'FE4AD4A6B68FF1211DD9DDE2F9BAEC83' is not recognized
what is this odbc driver doing? why is it trying to convert dates & varchars into numbers?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|