Configuration Options

BI xPress ›› Features ›› Auditing ›› Workbench ››
Parent Previous Next

Configuration Options


The Configuration Options section allows users to specify whether or not they wish to add a configuration file or parameters to their packages in order to control the behavior of the Auditing Framework. The configuration options as well as the scope of the parameters (whether package or project level) change depending on the deployment model selected on the Select Packages page.



1.   Use Configurations: Enables the usage of configurations


2.   Configuration Type: Displays the current type of configuration that will be used. The type of configuration displayed within this property is dependent upon the version of SSIS and the deployment model being used by the select packages.


o   Package Configuration File: Package Configuration files will be used if SSIS 2005, 2008, or 2008 R2 packages were selected.

1.   Configuration Folder: Controls the location the configuration file will be saved in.

2.   Overwrite if the configuration file already exists: Controls whether or not the configuration file will be overwritten if it already exists.

o   Package Deployment Model: Package Parameters will be used if the user selected SSIS 2012 and above and they also selected My Computer, SSIS Solution, SQL Server, or SSIS Package Store as the selected location on the Select Packages page

o   Project Deployment Model: Project Parameters will be used if the user selected SSIS 2012 and above SSIS Packages and they selected SSIS Project as the selected location on the Select Packages page

3.   Enable / Disable entire Auditing Framework: This configuration will allow users to manually turn off the Auditing Framework

4.   Enable / Disable variable, parameter, and connection logging: This configuration will allow users to manually turn off the logging of variable, parameter, and connection managers

5.   Enable / Disable real-time Data Flow monitoring: This configuration will allow users to manually turn off the Auditing Framework's real-time Data Flow monitoring.

6.   Enable / Disable logging for all warnings: This configuration will minimize the amount of logging that occurs by not logging warnings that occur during execution

7.   Variable and connection filtering: This configuration allows users to manually mask sensitive values contained within variables from being displayed when executions are viewed within the Monitoring Console.


Once done setting additional configuration options, users can continue to any of the following sections:

  Database Connection

  Connection Manager

  Package Grouping

  Logging Option


Users may also immediately begin applying or removing the auditing framework.