I am trying to implement the SQL Audit reporting and am running into errors.
I am running it in on SQL 2014, but have upgraded the package. I am getting issues on the load log data flow. The issue appears to be with the read audit log file step. I had to modify the function aud.fn_auditfileget in order to work correctly. That is working
fine when I run manually by itself with a filename passed in. I cannot figure out how the package is calling this command and what filenames and parameter it is passing.
My troubleshooting has come to a max and I cannot figure it out.
Error I am getting:
[read audit log file ] Error: 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 11.0" Hresult: 0x80040E14 Description: "The specified values for initial_file_name and audit_record_offset do not represent a valid location within the audit file set.
Verify the file name and offset location, and then rerun the command.".