Given that I have received some inquires asking for more details about the
odd behavior I am seeing in the OLE DB editor when pointing to a Netezza table, I decided to create a short clip showing the described behavior. Here are my observations:
- The ‘FastLoad’ options of AccessMode property are not available via OLE DB destination editor, and you have to use the properties window instead.
- AccessMode property may be silently reset to its default value ‘OpenRowset’ which does not use FastLoad.
- Using “OpenRowSet with FastLoad” will perform better than “OpenRowset” by orders of magnitude.
At this point it is not clear to me if this is an SSIS related issue or if it is rather a problem with the OLE DB driver provided by Netezza. I will post an update as soon as I have more information available
You can watch the video here:
Do not use "open rowset with fastload" if you have several ressources accessing the same table at the same time.
ReplyDeletefastload will integrally lock the whole table to insert the data.
So if only one process, it's ok and fast, but with several process it will create problems.
Rgds,