Which OLE DB Provider to Use for DB2

I often use one of these two OLE DB provider for DB2:

• IBM OLE DB Provider for BD2
• Microsoft OLE DB Provider for BD2

or

I don’t know all the differences between these two drivers, but here is what I’ve noticed:

• IBM OLE DB Provider for BD2 supports the use of in-session temporary tables in DB2 with the WITH statement, while the Microsoft driver does not.

With IBM OLE DB Provider for BD2, here is a typical Data Flow step. The Data Conversion is typically used to convert Unicode strings to ANSI strings, assuming that we are not using the Default Code Page of ANSI 1252.

(not using the Default Code Page of ANSI 1252 with IBM provider)

(IBM OLE DB Provider for BD2 supports the use of in-session temporary tables in DB2 with the WITH statement)