Adding Data Lookup to a project opens a property window. Use the property window to define the Key Attribute, Value Attribute, connection parameters, and query options.
The following procedure assumes that the lookup data is extracted from a text file.
To use the Data Lookup component
Add the component to the project.
Connect the upper IN-Port (Main) with the OUT-Port of the previous component, that will provide the data, containing the key to be looked up, to the Data Lookup component.
Add a Text Data Provider component to the project.
Connect the lower IN-Port (Lookup) of the Data Lookup component with the OUT-Port of the Text Data Provider component.
Specify all data that is required to set up the Text Data Provider Component. Make sure that a proper column definition for the file is provided.