Using saved queries in SQL transformations
Configure an SQL transformation to use a saved query on the SQL tab of the Properties panel. You can use one saved query in an SQL transformation.
1On the SQL tab of the Properties panel, select the connection that contains the tables that you want to run the query against.
2Set the SQL type to SQL Query.
3Set the query type to Saved Query.
4 Select the saved query that you want the SQL transformation to process.
For more information about SQL transformations, see Transformations.