• They do provide fn_get_audit_file but you have to execute it on the server against files that can be reached from that server. Then again it isn't all that different from errorlog files or trace files. MS provides a sproc to get at them but not an SSIS component.

    I was just thinking that maybe WMI could do it. I'm going to look at that.

    Also some of my reading indicates that the sqlaudit files are either XML or compressed XML files.

    CEWII