How to setup a high speed data load from SSIS package to Netezza database

1.  On the SSIS OS install the NPS OLE DB driver by running:

nzoledbsetup.exe (for 32 bit systems)

OR

nzoledbsetup64.exe (for 64 bit systems). 

2.  In SSIS connection manager create connections to your data source(s) and target.  Use Netezza OLE DB provider when defining connection to Netezza.

3.  In SSIS define the data source as per normal (flat file, ODBC source, OLE DB source, etc...)

4.  In SSIS use the “OLE DB Destination” object to send data to the target, Netezza.

5.  In the OLE DB Destination object properties set the following parameter values so that SSIS invokes Netezza’s high speed loader properly.  This dialog box is shown in the screenshot below.

Set AccessMode                                           = OpenRowSet using FastLoad

Set AlwaysUseDefaultCodePage             = true

Set FastLoadMaxInsertCommitSize        = 0