Hi, I am trying to insert log information into netezza db from ssis package. i have used "SSIS log provider for SQL Server" log provider. but i have got the below error message.
Log provider "SSIS log provider for SQL Server"] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Netezza Performance Server" Hresult: 0x80004005 Description: "ERROR: 'sp_ssis_addlogentry ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?'
error ^ found "SP_SSIS_ADDLOGENTRY" (at char 1) expecting a keyword".
This provider can be used only to insert log information into SQL server or to any other db as well?.
if not, is there any provider to be used for netezza? or is there any work around to insert logging information into netezza db table.
Any help would be greatly appreciated!
View Complete Post