I'm trying to implement the SQL Server logging in my package but Im receiving a very weird error message. Follow below:
ÃÂ "Error at Consumer_Common_Transportation [Log provider "SSIS log provider for SQL Server"]: An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available.ÃÂ Source: "Microsoft SQL Native Client"ÃÂ Hresult: 0x80040E14ÃÂ Description: "There is already an object named 'sysdtslog90' in the database.
Error at Copy Data to TCARRIER: The SSIS logging provider "SSIS log provider for SQL Server" failed with error code 0xC0202009 ((null)).ÃÂ This indicates a logging error attributable to the specified log provider.
I know that the sysdtslog90 table exists ( with no rows ), but i cant understand why this process doesnt includes rows/data in this table.
I alsoÃÂ have the Text file logging in this package and it is working fine. I just need to fix this issue to move it to production.
Does anyone knows what is happening? Is there any property or flag that i need to change?
Thanks in advance for your help.
View Complete Post