Charles's Host Integration Server Ramblings

The intent is to share some knowledge about Host Integration Server (HIS) that are not well documented, not well known, as well as various tidbits that come up when supporting HIS and all the various components.

Browse by Tags

Tagged Content List
  • Blog Post: Performance Testing the Microsoft OLE DB Provider for DB2 (Part 2)

    Technorati Tags: Data Providers , DB2 , Host Integration Server , Microsoft OLE DB Provider for DB2 , OLEDB , Performance , SSIS , SQL Server In my previous entry, I covered testing SQL queries using the Microsoft OLE DB Provider for DB2 using a linked server, but many customers really need to test performance...
  • Blog Post: Performance Testing the Microsoft OLE DB Provider for DB2 (Part 1)

    Technorati Tags: DB2 , SQL Server , SSIS , Microsoft OLE DB Provider for DB2 , Host Integration Server , Data Providers , Performance , OLEDB There are many factors that can affect pulling data from DB2 into SQL Server (or other applications). These include the network speed, hard drive; machine CPU...
  • Blog Post: DB2 Code Page Fun

    A while back I had a customer who was importing data from AS/400 DB2 tables into SQL Server, using SSIS, and we came upon an interesting error. The below describes how to actually reproduce the issue, and the fix. The fix is currently in all versions of our DB2 Data Provider at this point (assuming you...
  • Blog Post: Importing CHAR() fields containing null values from DB2 to SQL Server via SSIS

    Earlier this year, I was working with a customer who was doing a mainframe migration from DB2 to SQL Server, and they were using SSIS to import the tables. Several of their columns were CHAR data types, with a null byte as the first byte of the field. The columns, when imported, all contained empty...
Page 1 of 1 (4 items)