Export Table to CSV

Question

Hi

I would like to output the contents of the table (including headers) to a CSV file. My script below is giving me "Access is Denied" error. How do I modify the script so it works?

-- Enable Xp_cmdShell  
EXECUTE sp_configure 'show advanced options', 1    
RECONFIGURE     
EXECUTE sp_configure 'xp_cmdshell', 1  
RECONFIGURE  

EXEC master..xp_cmdshell 'sqlcmd -s, -W -Q "SELECT* FROM DBO.Table" | findstr /v /c:"-" /b > "C:\Users\Me\file.csv"'

-- Disable Xp_cmdShell 
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'xp_cmdshell', 0
RECONFIGURE
GO

Thank you

Answer 1

"Access is Denied"
"C:\Users\Me\file.csv"'

Of course you get access denioed, it's your user folder and only your account (+admins) to have access permissions for, but not SQL Server service account. Use a more approbiate folder and set access permissions for.