Metadata Collection - SQL Server Integration Services Design Patterns - page 12

Figure 1-7 . The Connection Manager
Note Permissions requirements vary depending on the type of metadata you wish to
retrieve. For more information on the permissions necessary to access a specific object,
please refer to the object type's page within SQL Server topics Online.
You now need to write the SQL statement that will retrieve the list of SQL Server
instances. Click the [ … ] icon to the right of the SQLStatement field, and then enter
the T-SQL code from Listing 1-4 .
Listing 1-4 . T-SQL Statement to Retrieve SQL Server Instances
SELECT SQLServerInstance FROM
dbo.dba_monitor_SQLServerInstances;