Using BI xPress

Guides to using all the features in BI xPress.


BI xPress Auditing Framework
Guide to using the Auditing Framework to track the activity for SSIS packages and get auditing information from SSIS package executions, such as errors and warnings.
BI xPress Best Practices Analyzer
Guide to using the Best Practices Analyzer to inspect SSIS packages and display recommendations based on best practices.
BI xPress Available Best Practices
Full list of best practices available in the BI xPress Best Practices Analyzer.
BI xPress BI Compare
Guide to using the BI Compare add-in to compare SQL Server objects down to the property level and display the results. You can save or export the comparison for future use.
BI xPress Compile Scripts
How to use the Compile Scripts Task in BI xPress.This task automates script compiling in SSIS packages.
BI xPress Config Tools
How to use the Config Editor to open existing configurations from XML files or SQL Table, and the Config Manager to create secure configurations and add or edit configuration values.
BI xPress Data Generation
How to use Data Generation to automatically generate valid data for a given schema, handle foreign key integrity for generated data, configure the volume of data, and more.
BI xPress Expressions
How to add and edit user-defined expressions, view all of the expressions and configurations within an SSIS package, and manage pre-written expressions for later use.
BI xPress MDX Calculation Builder
Guide to creating complex MDX calculations from several available MDX templates quickly (with no manual coding).
BI xPress Monitoring
Complete guide to using the monitoring and report monitoring consoles, and their related dashboard reports.
BI xPress Notifications
How to create notification event handlers on events such as OnError, OnWarning, OnSuccess, and OnComplete for any SSIS packages.
BI xPress Package Tools
Guide to using the SSIS Package tools in BI xPress (Package Deployment Wizard, Package Builder (including SSIS templates), and Package Sorter).
BI xPress Report Mover
How to move SSRS reports from one server to another using Report Mover in BI xPress.
BI xPress Snippet Wizard
How to use templates to quickly add script tasks to a package control flow, and standardize scripting among teams of developers by sharing scripts through the script wizard.
BI xPress SSIS Catalog Import
How to import native performance & execution data from an SSIS catalog to the auditing database for packages that do not have the auditing framework (to view execution data).