I thought I woud pass on some helpful information with a problem we been experiencing writing to DB2.
It seemsÃÂ that the SSIS OLE DB destinationÃÂ component
ÃÂ experiences problems using the IBM DB2 Driver
during validation when writingÃÂ toÃÂ large DB2 tables ~ 4 million rows. Usually results inÃÂ a "out of memory" error.ÃÂ We have open a case with Microsoft.ÃÂ ÃÂ
Until this can be fixed there are severalÃÂ alternativesÃÂ
1. If youÃÂ want to use the OLD DB Destination Component
ÃÂ create a view on the Table and add a Where 1=2 so no recordsÃÂ returnÃÂ
2. Use the OLE DB Command component
ÃÂ ÃÂ .. Insert into table (col1,col2)ÃÂ values (?,?)ÃÂ - this is actually 2 x faster
has a excellent DB2 Destination
custom component that uses IBM Db2 driver bulk copy APIÃÂ it'sÃÂ 20x faster - very impressive!ÃÂ http://www.cozyroc.com/ssis/db2-destination
hope this helps..
View Complete Post