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.

Options

• 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

Reference

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