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
| Release | History |
|---|---|
12 December 2006 |
|