• subscribe
May 14, 2009 12:00 AM

Standardize Your SSIS Package Deployments

SQL Server Pro
InstantDoc ID #102116

Pragmatic Works has released a new product called BI xPress, which lets you standardize your SSIS package deployments. With this product, you can add automated auditing, monitoring, historical, and notification reports to packages. BI xPress offers drag and drop functionality, making it faster and easier to create, deploy, and validate SSIS packages.

This product includes a deployment utility that lets you deploy multiple SSIS packages, and their configuration files, at one time. BI xPress also features an auditing framework that lets you track how long packages take to execute using seven built-in reports, and a notification framework that automatically sends out email messages and text messages in the event of SSIS package execution problems.

BI xPress integrates with both Visual Studio (VS) and Business Intelligence Development Studio (BIDS). This integration with BIDS lets you add a framework that follows best practices written by SQL Server MVP Brian Knight to your SSIS packages.

This product supports SQL Server 2008 and 2005. To learn more about BI xPress, and to download a free trial of the product, visit www.pragmaticworks.com/products/Business-Intelligence/BIxpress/Default.aspx

Related Articles:
SSIS Logging and Data Auditing
Debugging and Logging in SSIS



ARTICLE TOOLS

Comments
  • Dustin
    3 years ago
    May 21, 2009

    I've personally had a few chances to use Pragmatic Works' BI xPress and it's very impressive. It takes about 10 clicks to apply an auditing and notification framework across an entire project or solution. Now I can find out when every single one of my packages start, end, if there were any warnings, or errors without having to open the package. All I do is check my email or cellphone for a textmessage. With the built in reports, I can even trouble shoot my packages without ever even opening the package istelf. Piece of cake! Nicely done, Pragmatic Works.

You must log on before posting a comment.

Are you a new visitor? Register Here