This article describes how to use xp_cmdshell and BCP to export data to CSV. One problem I ran into was the error “Unable to open BCP host data-file”. This turned out to be a file permission issue. I had to give NETWORK SERVICE (the local account that runs my SQL Server service) Full Access rights to the queryout directory. I also had to use the –S flag to specify which SQL Instance (my server has two) to connect to:
EXEC xp_cmdshell 'bcp "SELECT * FROM <my database>.dbo.account" queryout "D:\queryout\bcptest.txt" -T -S "<my server>\<my instance>" -c -t,'
Posts
2 comments:
WHY ISN'T THERE ANY OUTPUT FILE?
There should be...the file path you set in queryout. Did you change the other parameters for your environment (e.g. server and instance)?
Post a Comment