Selecting Packages

BI xPress ›› Features ›› Auditing ›› Add-in ››
Parent Previous Next

Selecting Packages


Depending on the action that was selected on the Select Actions page, the Select Packages page allows users the ability to select which packages they wish to have the Auditing Framework added / re-applied or removed. 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



The Select Packages page is divided up between the package location and selection areas.


Package Location

Controls where the Auditing Framework will search for the SSIS packages that the user wishes to have the Auditing Framework added / re-applied or removed. There are five locations the user can select.



1.   File System: The Auditing Framework will search the File System, using the selected path, for SSIS Packages. Users can check the Recursive option to scan the select File System folder and sub-folder(s) for SSIS Packages. Packages selected in this way will have the Auditing Framework added / re-applied or removed using the Package Deployment Model.


2.   SQL Server: The Auditing Framework will search SQL Server, using the provided connection information, for SSIS Packages deployed. Packages selected in this way will have the Auditing Framework added / re-applied or removed using the Package Deployment Model.


3.   SSIS Project: The Auditing Framework will search an SSIS Project File (*.dtproj), using the selected path, for SSIS Packages. If the packages are SSIS 2012 or above, packages selected in this way will have the Auditing Framework added / re-applied or removed using the Project Deployment Model.


4.   SSIS Package Store: The Auditing Framework will search the SSIS Package Store, using the provided connection information, for SSIS Packages deployed. Using this location requires the Auditing Framework to be running as the Administrator account. Packages selected in this way will have the Auditing Framework added / re-applied or removed using the Package Deployment Model.


5.   Visual Studio Solution: The Auditing Framework will search a Visual Studio Solution (*.sln), using the selected path, for SSIS Packages contained within SSIS Projects associated with the selected solution. Packages selected in this way will have the Auditing Framework added / re-applied or removed using the Package Deployment Model.

Package Selection

Controls which package from the selecting location will have the Auditing Framework added / re-applied or removed.



1.   Filter: Located at the top left of the Package Selection, the Filter allows the users to quickly filter out packages they do not wish to see when selecting packages.

2.   Browser: Located just underneath the Filter on the left, the Browser contains all packages from the location that have not been filtered.

3.   Selection Buttons: Located underneath the Browser on the bottom left, the Selection buttons allow the user to quickly select or unselect all packages from the browser.

4.   Scan Packages Button: Located underneath the Browser on the bottom, the Scan Packages button allows users to quickly select or unselect packages based on a set of parameters. Clicking the Scan Packages button will launch the Scanning Option window


1.   Scan For: Controls which frameworks (Auditing and / or Notification) that the Auditing Framework will scan for within each package.

2.   When selected framework: Controls whether the Auditing Framework is searching for the presence or absence of the selected frameworks.

3.   List item action: Controls what action, whether to select, unselect, or ignore, the Auditing Framework when a package meets the parameters selected in step 1 and 2.

4.   Sort list after scanning?: Controls whether to sort the list of packages after scanning for the Auditing or Notification framework.

6.   Selected Items: Located on the right of the Package Selection, the Selected Items allows the user the ability to see all the current packages that are selected from within the Browser to have the Auditing Framework added / re-applied or removed.


After selecting which packages the user wishes to have the action applied to, clicking the Next button will send the user to different pages depending on both the action selected on the Select Action page:


  Adding / Re-applying Auditing Framework: If the user is adding / re-applying the Auditing Framework, clicking Next will send the user to the Options page to begin configuring the Auditing Framework.


  Removing Auditing Framework: Depending on the location and version of the SSIS Packages selected, clicking the Next button will send the user to different pages when removing the Auditing Framework:

1.   Project Deployment Model: When removing the Auditing Framework from SSIS 2012 or above packages using the SSIS Project location, clicking next will send users tot he Project Items Removal page to configure options on removal project items from the selected SSIS Project.

2.   Package Deployment Model: Clicking next will send users to the Summary page to begin the process of removing the Auditing Framework from the selected packages.