Avatar of robertfl77

asked on 

Best approach for history retention in SSIS ETL

I am looking for advise what would be the best approach for storing history of ETL load. The way ETL works is I am receiving flat file and it is loaded to staging area and from staging area to a production table and to a view
What would be the best approach in case I got duplicate file and load it I do not want that to happen
SSIS* ETLMicrosoft SQL Server

Avatar of undefined
Last Comment
zephyr_hex (Megan)

8/22/2022 - Mon