Well your suggestions worked.

After I was going to post the DDL, I noticed an error in the SQL statement.

And as I fixed that, the xp_cmdshell to create the file worked.

So now I need to figure out, out of all the steps I tried. To back out and then put in the basics.

And have the proc execute as owner, and give the proc execute permissions to the role that is running from the application.

Your steps worked. thank you so very much.

thanks again.