SSIS Assets
Last Modified on 01 February 2023
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.
|