sqldriver (2/15/2014)
I really hate SSIS and was hoping to avoid it. I guess I could try doing this all in another language that handles large file operations better. Of course, since these are all going to garbage staging tables, I could always generate dynamic import statements with extra variables. Hm.Who cares about filling up transaction logs, anyway?! :w00t:
SSIS is perfect for this using a derived column that looks at the file name. I could have set it up in about the time it took you to post.