First of all, thank you for taking the time to help me!

I built the proc to print, then executed it: exec Dbo.BulkLoad_1 '#LoadTbls.TblLoc' ;

It printed the DML to execute the...

Thanks Ron. The bulk insert I provided has the file path and name hardcoded. I'd like to pass in several file path and name so I don't have...