The SSIS asset allows for a quick way to reference a package for tests multiple times, without the need to re-select it for each test you want to execute against it.
Package Reference
Icon
Description
The Package Reference assets holds the location of an SSIS package. SentryOne Test has support for 2008, 2012, 2014, 2016 and 2017 packages. Browse for a package stored in a file system, or provide the connection string for packages stored on a server or catalog. The catalog option is only available for 2012, 2014, 2016 and 2017 package references. Once the file location is added or the connection string is supplied, select Load to obtain a list of available packages. Once selected, the package can be loaded using the Load Package action.
For 2008, 2012, 2014, 2016 and 2017
File Tab
Function
Description
File
Location of the package on the file system. The user can either type in directly, or use the browse button to search the machine for location of the package.
Selected
Specify a location and select load to populate the area with available packages.
SQL Tab
Function
Description
Connection
The connection string to the location of stored packages. This can either be typed or pulled from an existing Connection asset.
Selected
Enter a connection string and select load to populate the area with packages found on the server.
For 2012, 2014, 2016 and 2017
Catalog Tab
Function
Description
Connection
The connection string to the catalog's location. This can either be typed or pulled from an existing Connection asset.
Selected
Enter a connection string and select load to populate the area with packages found in the catalog.