Property | Description |
|---|---|
Simple | Select to view the lookup query and apply a filter on the lookup. |
Advanced | Select to view the query, customize the query, or run the query in the database that contains the relational lookup table. |
Filter | Enter a filter to reduce the number of rows the Integration Service queries. You must select the Simple option to view this option. |
Use Custom Query | Select to override the lookup query. You must select the Advanced option to view this option. |
Push Custom Query to Database | Select to run the query in the database that contains the relational lookup table. You must select the Advanced option to view this option. |
SQL Query | Displays the SQL query used to perform the lookup. You can customize the SQL query. You must select the Advanced option to view this option. |