Hi @Adam Quark ,
We can use OLEDB source and Lookup Transformation to get match data and no match data.
We should set Specify how to handle rows with no matching entries as Redirect rows to no match output in Lookup general page.
Please refer to the following pictures:
Best Regards,
Mona
----------
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.