SSIS - How to create Folders as Month Name in SSIS Package

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.

How to create folder with Month Name in SSIS Package


  1. 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.

    SSIS Upsert

  2. This comment has been removed by the author.

  3. Thanks for the article post. Really looking forward to read more. Fantastic.
    Transfer large files