I have a query that I want to execute as a stored procedure, so I can schedule it. I need the results to be exported to a csv file format. I have created a batch BCP script to run the query and dump the results to a file, but when I try to run the xp_cmdshell in my stored procedure, it is not cannot be found. I assume it is not installed. I viewed the advanced settings and it wasn't even listed.
How can I go about this in another way? Any ideas? I have 2 queries that are running data, and the 3rd query is pulling the summary of this data to a file. If you can help me out, please let me know. Thanks!