[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSIS Auditing Template and/or SSIS Best Practices for Auditing

Posted on 2011-05-05
3
Medium Priority
?
1,173 Views
Last Modified: 2013-11-10
Experts,

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.

Thanks
0
Comment
Question by:MIKE
3 Comments
 
LVL 22

Accepted Solution

by:
8080_Diver earned 1000 total points
ID: 35699938
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.
0
 
LVL 9

Assisted Solution

by:radcaesar
radcaesar earned 1000 total points
ID: 35699952
0
 
LVL 17

Author Comment

by:MIKE
ID: 35701701
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

http://www.sharepointpromag.com/article/business-intelligence-development-studio-bids/ssis-logging-and-data-auditing
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

867 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