Hi, I haven't been able to find anywhere how to do or which transformation to use.
I've seen Lookup but it only has one input, merge join but I could only get it to append...
I'm using SSIS 2019 Community in VS with Windows 10.
I've brought in two tables using flat file source nodes
They both have a PK of TransID that has been sorted, I'm looking for the best next step.
I've seen that you can go to the ToolBox items and check the Table compare option but I don't have that available.
Can someone suggest a nice quick easy method to join 2 tables to a Transformation, link the TransID PKs & output a matched * not matched output??