depends on how do you want to run the store procedure.
for example, use xp_cmdshell, and specif/define the destination.
or create sql agent job to combine batch, or powershell script .
or add a separated SSIS project if you use visual studio and you want to manupulate the SSIS project result...