Contents tagged with DB2OLEDB

• DB2 timestamps and SQL Server

  Thursday, April 13, 2017

  SQL SSIS DB2 DB2OLEDB datetime2 DBTYPE_DBTIMESTAMP

  No Comments

  I've been working with a document database in DB2, getting the document metadata into a SQL Server data warehouse. I've run across some issues with the way DB2 timestamp data types are converted into SQL Server datetime2 when you access the DB2 server via a linked server in SQL.

  Read more...