The Logging tab allows users the ability to customize how the Auditing Framework will control Data Flow, Variable, and Connection Manager logging. The Logging Options tab is divided up into three sections, each controlling three different areas of the Auditing Framework's logging.
Data Flow logging
The Data Flow logging section controls logging details within each Data Flow present within each SSIS Packages.
1. Enable Real-time Data Flow Monitoring: Controls whether or not the Auditing Framework will monitor data flows in real-time
If real-time Data Flow monitoring is turned off, some of the features of Monitoring Console's Execution Diagram will be unavailable
2. Log Row Counts: Controls whether or not the Auditing Framework will capture row counts flowing inside data flows. When enabled, each data flow will be modified to track row count data.
1. Log Source Row Counts: If log row counts are enabled, Log Source Row Count will track how many rows are coming from source components.
2. Log Destination Row Counts: If log row counts are enabled, Log Destination Row Counts will track how many rows are going to destination components.
3. Source SQL Statement Logging: If log row counts are enabled, Source SQL Statement Logging will log SQL Statements used to extract data. This information can be viewed using BI xPress' Extract / Load Detail Report.
4. Connection Detail Logging: If log row counts are enabled, Connection Detail Logging will log details for each source and destination component regarding the connections used.
Variable, Parameter, and Connection
The Variable, Parameter, and Connection logging section controls logging details for Variables, Parameters, and Connection Managers within each SSIS Packages.
1. Log Connections: Log Connections allows users to log every connection manager's connection string value during run-time
o Connection Masking: Connection masking allows users the ability to hide the connection string for sensitive connection managers. Wildcards can be used for partial matching. If no wildcards are used, then the masking value will only match a connection manager's full name. Place multiple masking values within their own rows.
2. Log Variables: Log Variables allows users to log the values of every variable when the package execution is started and when the package execution completes
o Variable Masking: Variable masking allows users the ability to hide the values for sensitive Variables and parameters. Wildcards can be used for partial matching. If no wildcards are used, then the masking value will only match a Variable's full name. Place multiple masking values within their own rows.
3. Enable Variable Change Tracking: Enabling Variable Change Tracking allows users to maintain a historical record of all value changes to variables during an SSIS execution.
o Variable Logging Type: The Variable Logging Type switch allows the user to choose between tracking all variables, or only variables used within For Each loops.
4. Object Variable Logging: If log variables are enabled, Object Variable Logging allows the logging of object variables
5. Initial Parameter Value Logging: If log variables are enabled, Initial Parameter Value Logging will also log the initial values of all non-sensitive parameters within SSIS packages 2012 and up
The Miscellaneous section controls other logging options that do not control details regarding data flow, variables, parameters, and connection managers.
1. Max Loop Iterations: Max Loop Iterations control how many loops within a For or For Each Loop they wish to document. Setting this value to 0 means to log all iterations
2. Script Language: Script Language controls which programming language the user wishes the Auditing Framework to use within Script Tasks
3. Log Warnings: Log Warnings control whether or not a user wishes to have warnings that are encountered during executions to be logged within the BI xPress database
Once done configuring the Logging Options tab with the desired settings, either click on the Connection Information, Advanced User Defined Logging, or Alert Filtering tab to continue configuring the Auditing Framework, or click the Next button to head to the Summary page to begin the process of adding / re-applying the Auditing Framework.