Skip to Content

Solved: Recommendation for third party tool to add auditing to SSIS package

Question/Problem Description

As a developer, I used VS DataTools to create simple, straight-forward ETLs to feed data into my projects. I get to know about using a 3rd party tool that adds auditing to SSIS packages. What tools should I use to help manage complexity and improve productivity?

Answer

Auditing does not help to manage complexity and/or improve your productivity. Maybe logging and tracing, but this is a different thing than auditing. Only need SSMS, stored procedures and SQL Server Agent jobs for this.

BI xPress which is part of the Pragmatic Workbench for auditing, but the product is EOL. The biggest way that auditing helps with productivity is when an SSIS package fails loading a flat file and it can pinpoint you to the line that’s causing the failure. If you have time-sensitive processes, that’s a benefit, especially when processing large files.

Idera is a company that has tools offer for free. I’ve used Idera’s free tools to examine the queries and identify indexes that need to be added for performance.

The most important SQL writing tool in SSMS: Redgate SQL Prompt can speed up SQL writing up to 25% to 75%.

The rest is using a source code repository and a good, automate test environment.

Alex Lim is a certified IT Technical Support Architect with over 15 years of experience in designing, implementing, and troubleshooting complex IT systems and networks. He has worked for leading IT companies, such as Microsoft, IBM, and Cisco, providing technical support and solutions to clients across various industries and sectors. Alex has a bachelor’s degree in computer science from the National University of Singapore and a master’s degree in information security from the Massachusetts Institute of Technology. He is also the author of several best-selling books on IT technical support, such as The IT Technical Support Handbook and Troubleshooting IT Systems and Networks. Alex lives in Bandar, Johore, Malaysia with his wife and two chilrdren. You can reach him at [email protected] or follow him on Website | Twitter | Facebook

    Ads Blocker Image Powered by Code Help Pro

    Your Support Matters...

    We run an independent site that is committed to delivering valuable content, but it comes with its challenges. Many of our readers use ad blockers, causing our advertising revenue to decline. Unlike some websites, we have not implemented paywalls to restrict access. Your support can make a significant difference. If you find this website useful and choose to support us, it would greatly secure our future. We appreciate your help. If you are currently using an ad blocker, please consider disabling it for our site. Thank you for your understanding and support.