Microsoft T-SQL

1)Need to create a Dynamic process to load data from File to landing tables
2) After loading into landing, the process should be able to perform scd and load into a different table.