Enter and execute a SQL query for databases associated with Source, Lookup, Staging, and Destination components.
- In the Design window, right-click the component
and select Execute SQL Query.
- 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 Open the Database Lookup icon.
- Click the Execute the Query icon.
On successful execution, the result appears in the Data Viewer
window.