SSIS Auditing Template and/or SSIS Best Practices for Auditing

Posted on 2011-05-05
Last Modified: 2013-11-10

I'm interestedin in hearing some real world examples on how to setup a SSIS Auditing Template for use with all of our SSIS packages enterprise wide.

Doesn't have to be too elegant, but funtional and of course something that will take care of most "real world" auditing issues that are faced. I'm in the Healthcare Data space and so any thoughts in this direction would help.

if you have an SSIS Auditing Template in place please share.

Question by:MIKE
    LVL 22

    Accepted Solution

    You might want to look at Pragmatic Works' BI-xPress rpoduct.  Among other features, it allows you to add auditing and notification frameworks to your existing SSIS packages and it provides some basic reports on the audit data.

    Please note: I am not affiliated with Pragmatic Works nor would I benefit in any way from your purchase of any products.  I just happen to think that it is a very good tool.
    LVL 9

    Assisted Solution

    LVL 17

    Author Comment

    Here is link that I found that I thought was helpful to me. I was hoping to find other links like tihs so as to make a comparison.

    But I guess these sample templates will give me a great start.....thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now