I have the below scenario
Columns: Name(Varchar), Active(bit)
Columns: Name2(Varchar), Active(bit)
I want SSIS to update the 'Active' column in table two depending on the value in 'Active' in table one. How can I do this in SSIS. I currently have two OLE DB Sources that then get sorted seperately, now im a little stuck on where / to join the two then put an update command in there for table2 based on table1?