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
Author
Message
Posted Wednesday, May 08, 2013 12:18 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 9:41 AM
Points: 95, Visits: 292
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:

[center]
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.".
[center]

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