Yeah, I think my plan is going to be using PS to generate a bulk insert for every file, naming the tables after the files before the .txt, and immediately afterwards an alter table add column with a default of a substring of the file name. That sounds cleaner to me.

Thanks