Configuring the eG Agent with the SSIS Version

The first step to achieving this is determining what is the correct version of SSIS. For this, login to the Microsoft SQL server host where SSIS is running, and open the Services window. Look for the service named, SQL Server Integration Services. Once you find the service, check the number displayed alongside the service name (as depicted by Figure 1). This number represents the SSIS version.

Figure 1 : Determining the version of SSIS

Make a note of the version number. Then, when configuring the tests for the managed Microsoft SQL Server Integration Server component using the eG admin interface, make sure you configure the SSIS VERSION parameter of the tests with the version number that you made a note of earlier. Ensure that the version number you specify is exactly the same as what is displayed in the Services window (see Figure 1).