• Mike, one thing we've found in dealing with the MS and IBM OLE DB providers for DB2:  the MS provider doesn't support BLOB or CLOB columns.  The IBM does, but it requires every CHAR field to be converted from NVARCHAR.

    Also, we seem to have trouble with the OLE DB connectors staying connected in our packages.  They burp for strange reasons, we go in and 'reconnect' the connectors (edit them and do a test connection) and then they work flawlessly.  Any suggestions?