MSDN Blogs

Posts

| |

|

Charles's Host Integration Server Ramblings

DB2 Code Page Fun

Posted over 5 years ago

by Charles Ezzell
- 1 Comments
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...
Charles's Host Integration Server Ramblings

Using PowerShell to Access DB2

Posted over 5 years ago

by Charles Ezzell
- 1 Comments
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...
Charles's Host Integration Server Ramblings

Importing CHAR() fields containing null values from DB2 to SQL Server via SSIS

Posted over 5 years ago

by Charles Ezzell
- 1 Comments
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...