Technorati Tags: Host Integration Server , DB2 , DRDA , DTC , Transaction This is something I knew a bit about, but not the whole story, so I had a talk with one of our developers, Vitaliy Golub, who very kindly explained to me (sometimes giving me a...

One issue that came to us recently was on how to replicate SQL data containing NTEXT and IMAGE columns to DB2. Replicating most other data is straightforward, but NTEXT and IMAGE is a bit of a problem. Currently our data provider does not support LOBs...

Internally and externally we get customer inquiries wanting to know how to get configuration and status information from Host Integration Server without using the manager interface. Well, this is fairly simple, but complicated if you are not familiar...

In Part 1 of this series I covered testing SQL queries using the Microsoft OLE DB Provider for DB2 using a linked server. In Part 2 I showed how you can test performance with SSIS. However, in many cases, customers may be using C# or VB.NET, writing web...

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

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

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

Yes, PowerShell can be used to access DB2 using The Microsoft Host Integration Server Data Providers. Not a tutorial, but here is the script, ran using HIS 2004’s data provider: $cn = new-object system.data.OleDb.OleDbConnection("Provider=DB2OLEDB;User...

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