Maybe I should ask this question in another group, but since I'm using it for
DTS... I don't know...

I'm copying data from DB2 and the existing packages use ODBC for DB2.
Should I switch to OLE DB? Is the performance better?

Thanks

Ok I performed a test: copy 5 000 000 records from DB2 to SQL Server.
ODBC and OLEDB completed the test with very similar results (12:40 vs 12:19).
So I don't know about other operations, but the difference seems
insignificant.

"fleo" wrote:

In my experience, the issue when pulling from a DB2 source isn't
OLE/ODBC connection, it's DB2. (weakest link in the chain perhaps) But
you might try restesting, insert some complicated grouping or
aggregates and see if the test results remain similar. I haven't done
any conclusive testing, but I've always heard OLE is more efficient
than ODBC.