Executing SQL Commands

Enter and execute a series of SQL commands for databases associated with Source, Lookup, Staging, and Destination components

1. In the Design window, right-click the component and select Execute SQL Commands.
2. Enter the SQL commands in the Command field. To create the command using tables and views from the available database schema, click the Open the Database Lookup icon.
3. Click the Execute the Commands icon.
   Note:

   Executing a series of commands does not return a result set.