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
0 comments: