Unfortunately you cannot do this directly in TSQL. However as was discussed in another thread you can create a job or executable to make a connection to the server and retrieve the output as well as insert that way into a table.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)