- Lookup Match Output
- Lookup No Match Output
Inside the OLEDB Command editor the first tab you are shown is the connection manager tab. Simply connect to the destination database and then select the component properties tab.
- Fixed Attributes, which means that the data in these columns won’t ever change, even if a change comes through from the source.
- Changing Attributes which corresponds to a Type 1 change.
- Historical Attributes which corresponds to a Type 2 change.