Creating tables in SSIS from flat files

SSIS and Import/Export
3
  1. Every day
  2. I'm not sure what would be best way to be honest
  3. I think in the whole they would be staging, we have to take 2 flat file reports, merge them, then do a look up with 2 look ups as well.

but I'm thinking it would be daft replacing the table each day, however there is the potential that fields may change as we implement it. It's being done on the fly as there is a rush as it's COVID absense reporting for the whole hospital, and they need it every morning.