This is the second post of my SSIS & Netezza series. In an earlier post I provided details about the environment I was working in. At this time, I would like to make a quick note about an interesting behavior in the OLE DB Destination when pointing to a Netezza table. When you open the OLE DB destination editor, there are no “fast load” options under the data access mode property.
For those not familiar with this property, using ‘fast load’ tells SSIS to attempt the load in batches of rows – typically 10k row batches – as opposed of doing row-by-row load/commit operations, that in general yields better performance. Now, the odd thing is that if you look into the properties pane of the destination component, then you see 2 extra options for ‘fast load’.
This means that after you set everything else up in inside of the destination editor, you also have to visit the windows pane of the component to setup the access mode property. Annoying, isn’t it? But wait there is more. If you ever have to open the destination component editor again, the access mode property will get reset to the default value ‘Open Rowset’, so you have to go to the properties window of the component one more time to select the fast load option.
I get the same behavior in SSIS 2005 and SSIS 2008 R2 when using the the Netezza OLE DB driver 5.0.8