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.
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.