It is common practice to archive files to folder/s after loading into our destinations in ETL process. The files are archived so we can take a look anytime if we need to.
In this video post, you will learn how to create folder as Month name dynamically each month.
In this video post, you will learn how to create folder as Month name dynamically each month.
How to create folder with Month Name in SSIS Package
I think you will not need a lookup transformation if you use SSIS Upsert. Although this is a third-party product but I still think it will be useful.
ReplyDeleteSSIS Upsert
This comment has been removed by the author.
ReplyDeleteThanks for the article post. Really looking forward to read more. Fantastic.
ReplyDeleteTransfer large files