Lookup Transformation Editor (Reference Table Tab)

Updated: 12 December 2006

Use the Reference Table tab of the Lookup Transformation Editor dialog box to select a connection and a reference table or query in which to look up values.

To learn more about the Lookup transformation, see Lookup Transformation.

OLE DB connection manager

Select an existing OLE DB connection manager from the list, or create a new connection by clicking New.


Create a new connection by using the Configure OLE DB Connection Manager dialog box.

Use a table or view

Select an existing table or view from the list, or create a new table by clicking New.


Create a new table by using the Create Table dialog box.

Use results of an SQL query

Browse to a preexisting query, build a new query, check query syntax, and preview query results.

All data returned by the query is cached unless you configure a Lookup transformation for partial caching by using the Enable memory restriction option on the Advanced tab of the Lookup Transformation Editor.

Build query

Create the Transact-SQL statement to run by using Query Builder, a graphical tool used to create queries by browsing through data.


Use this option to browse to a preexisting query saved as a file.

Parse Query

Check the syntax of the query.


Preview results by using the Preview Query Results dialog box. This option displays up to 200 rows.

Configure Error Output

Specify how the component should handle row-level errors by using the Configure Error Output dialog box.

Release History

12 December 2006

New content:
  • Added information about caching data returned by a SQL query.

Community Additions