Hi @Aidan Devlin,
If the two servers are on the same domain or same machine, no linked servers are needed, SSIS can connect to the databases directly. Please have a double check.
You may use Lookup Transformation to ensure there are no duplicates.
If I misunderstand your issue, please incorrect me.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.