Interesting solution. Thanks for bringing those undocumented xp's to light. 🙂

Personally, I'd do a couple things different. It's probably the programmer in me, but I'd replace sp_GetFiles, and sp_FolderFileExist with functions. Then instead of working with ##Temp tables, your curser would be based on

select * from dbo.GetFiles(@myfolder)

I'd also use BCP instead of DTS to load the files. Again, personal preference.

(Johnhind, I'd put money on dts bulk load or bcp over any vb solution.)

Thanks again,

John