• Yes, this can be done with SSIS.

    Declare a variable, set up a For...Each...Next loop that goes through the files in the folder, and assign the file name to the variable. Use the variable as part of a file-system-object command to create a folder. Very straightforward.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon