Selecting Packages

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

Selecting Packages


The Select Packages page allows users the ability to select which packages they wish to apply or 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


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.   My Computer: The Auditing Framework will search the File System, displaying all SSIS packages within each directory as the user expands and collapses folders. Packages selected in this way will have the Auditing Framework applied or removed using the Package Deployment Model.


2.   SSIS Project: The Auditing Framework will search an SSIS Project File (*.dtproj), using the selected path, for SSIS Packages. If the packages selected are SSIS 2012 or above, then the selected packages will have the Auditing Framework applied or removed using the Project Deployment Model.


3.  SSIS 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 applied or removed using the Package Deployment Model.


4.   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 applied or removed using the Package Deployment Model.


5.   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 Pragmatic Workbench to be running as an Administrator. Packages selected in this way will have the Auditing Framework applied or removed using the Package Deployment Model.


6.   SSIS Catalog: The Auditing Framework will search the SSIS Catalog, using the provided connection information, for SSIS Packages deployed. Packages selected in this way will have the Auditing Framework applied or removed using the Package Deployment Model.

 

Package Selection

The Package Selection screen allows users to browser through the selected location, expanding and collapsing folders, selecting all SSIS packages that the user wishes to have the Auditing Framework 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 the Database Connection page.