Home > SSIS Best Practices > Which OLE DB Provider to Use for DB2

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

image

or

image

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.

image

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

image

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

image

Categories: SSIS Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: