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

Figure 1-6 . The Execute SQL Task Editor
In the Configure OLE DB Connection Manager menu, click New. In the Server
Name field, enter the database server where you created the database in Listing 1-1 .
Regardless of whether you are using Windows or SQL Server authentication, make
sure that the account has sufficient permissions to each of the instances in your
dba_monitor_SQLServerInstances table. Under Select or Enter a Database
Name, select dbaCentralLogging from the drop-down menu, as illustrated in Figure
1-7 . Click OK to return to the Execute SQL Task Editor.