Executing SQL queries and commands

You can enter and execute a SQL query or 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 Query.

2. Enter a select statement in the Query field. You can use any valid SQL notation of the connected database to build the query. To create the query using tables and views from the available database schema, click the Database Lookup icon.

3. Click the Execute the query icon.

   On successful execution, the result appears in the Data Viewer window.

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 Database Lookup icon.

3. Click the Execute the command icon.

   A message appears on successful execution of the SQL commands.

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