Contents tagged with DB2

• 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...

• Trouble finding the Microsoft OLEDB Provider for DB/2 install package?

  Friday, March 31, 2017

  OLEDB DB2 DB2OLEDBV4

  No Comments

  Today I needed to install the Microsoft OLEDB Provider for DB/2. A quick search brought up this download page:

  Read more...