Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Error when logging Expand / Collapse
Posted Wednesday, May 8, 2013 12:18 PM


Group: General Forum Members
Last Login: Tuesday, September 22, 2015 6:25 AM
Points: 110, Visits: 394
I am trying to familiarize myself with SSIS logging to SQL Server, and there is one error I'm having trouble getting past. I'm using the same OLEDB connection that I have set for my destination, and I have verified that the sysssislog table and the sp_ssis_addlogentry stored proc have been created. When ever I try and debug the package, though, I get the following:

Error at Package [Log provider "SSIS log provider for SQL Server"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E14 Description: "There is already an object named 'sysssislog' in the database.".

This error is repeated several times, but I have no idea what to do with it. Is there a way to get it to validate the existence of the table before executing?
Post #1450735
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse