• Really nice article, with a lot of how-to's.

    I cannot stop raving about the added flexibility, such as what is described in the article, which will make SSIS king of all ETL tools for years to come.

    If you want to really get funky, add an ADO enumerator on top of this (for example, if you are processing an archive with 300 files, all with a datestamp attached, and you want to move them to monthly archive folders which dont exist, have a SQL task that strips out the month and adds distinct months into the ADO enumerator).

    This will allow you to add folders for the respective month, and a for each file enumerator inside the for each ADO enumerator, with a restrictive wildcard will allow you to only move those files belonging to the month you just created.

    Also, add some package configurations, which will allow you to port your solution to any environment.

    Key requirement is naturally that the SQL server agent account has write access to the folder.

    My 5 cents worth.

    ~PD