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?