How would I do this in SSIS? - I have an Excel file that has columns: A and B - DB table has these columns too. - The SSIS task is to update column B in the DB table with the value supplied by column B that matches column A in the spreadsheet.
A B 123 abc
If 123 exists in the table then for that record, update column B with abc.
Load the excel file in ssis into a "staging" table - just some other table with the same layout. Next task in the SSIS package must be a sql task which will be a Merge statement or a update statement setting column B to the value of B from the staging table where there is a match on the values of column A of both tables.