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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.