The Add-in manages the auditing framework from within a user's development environment.
Below is a list of all supported development environments:
• Business Development Studio (BIDS)
• Visual Studio (VS)
• SQL Server Data Tools (SSDT)
Table of Contents
The Auditing Framework can be launched by either locating the BI xPress toolbar at the top of the development environment or by right-clicking a SSIS Project or Package within the Solution Explorer. In both cases, there will be an option to select "Add / Remove Auditing Framework (BI xPress)", this option will immediately launch the Auditing Framework.
Once the Auditing Framework has loaded, there will be a series pages that will help users configure the Auditing Framework for their package(s). These pages change depending on whether the user wishes to add or remove the Auditing Framework. Below can be found a list of all pages found within the Auditing Framework, a brief description of their function, and a link to more details:
1. Select Action: The Select Action page allows users the ability to choose whether they wish to add / re-apply or remove the Auditing Framework from their SSIS packages. Depending on which action they choose, the available pages will change. Below can be found the underlying differences between Adding / Re-applying and Removing the Auditing Framework:
Adding / Re-applying the Auditing Framework
1. Select Packages: When adding / re-applying the Auditing Framework, the Select Packages page allows users the ability to select which packages they wish to add / re-apply the auditing framework. This page also controls the behavior for which deployment mode will be used by the Auditing Framework when working with SSIS 2012 and above packages
2. Options: When adding / re-applying the Auditing Framework, the Options page contains four tabs that control all of the options used to customize the Auditing Framework
1. Connection Information: The Connection Information tab allows users the ability to configure the BI xPress database, connection manager, and configuration file / parameter options
2. Logging: The Logging tab allows users the ability to customize how the Auditing Framework will control Data Flow, Variable, and Connection Manager logging
3. Advanced Logging: The Advanced Logging tab allows users to explicitly specify the logging of specific variables within the Auditing Framework.
4. Alert Filtering: The Alert Filtering tab allows users the ability to define a set of warnings they wish for the Auditing Framework to ignore when encountered
Removing the Auditing Framework
1. Select Packages: When removing the Auditing Framework, the Select Packages page allows users the ability to select which packages they wish to remove the auditing framework. This page also controls the behavior for which deployment mode will be used by the Auditing Framework when working with SSIS 2012 and above packages
2. Project Items Removal: When removing the Auditing Framework and selecting packages using the SSIS Project Location, the Project Items Removal page provides users with the ability to specify whether or not they wish for project items, such as the BI xPress project connection manager and parameters, to be removed
2. Summary: The Summary page provides users with information, warnings, and errors that may occur during the application or removal of the Auditing Framework
Navigating between the above pages can be done by using the back and next buttons located on the lower right of each page