PJ_SQL (11/21/2016)
Yes it would need to update multiple files in the table.Are you implying that I import the file received from third party to a table and then update each table ?
Tables do not have files - what do you mean?
Yes, that's what I was implying.
It's not the only way, but it's the way I would do it. Keep the DB logic in the DB and use SSIS to move data around.