How is this procedure going to be called, will it be run manually from SSMS bcp and powershell would both be command line tools would you run it manually there? Do you plan to automate it? Will it be called by an external service of some kind?