[Dan In Van Contributions: 0Level 1☆]

Hi,

I’m just wondering if anyone else has come across any data type issues when using ODBC (driver version 7.02.00.54).

The issue that we’re having is that none of the data types are being recognised correctly across any of the applications that we use which use the system DSN created during the ODBC setup process.

All fields are either coming through as either nvarchar(4000) or float and nothing matches the data types specified in the connect schema documentation.

Is there a way to configure the codepages or data types of the ODBC connection itself as no amount of tweaking source/input/output properties in applications such as SSIS will change them and we are presently having to convert all data at the time of extraction from the odbc source which is impacting performance and unnecessarily complicating our ETL processes.

Thanks

Dan
This is a cached copy. Click here to see the original post.

[Author]

Posts