Lookup Transformation Editor (Reference Table Tab)

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.
  • 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.
  • 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.
  • Browse
    Use this option to browse to a preexisting query saved as a file.
  • Parse Query
    Check the syntax of the query.
  • Preview
    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.

See Also


Lookup Transformation Editor (Columns Tab)
Lookup Transformation Editor (Advanced Tab)

Other Resources

Integration Services Error and Message Reference
Fuzzy Lookup Transformation
How to: Implement a Lookup Using the Lookup Transformation

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

12 December 2006

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