Scheduled SQL Server Data Export to CSV using SQLCMD

Question

This is my command line:

sqlcmd -S DEVSERVER\SQLEXPRESS -i  c:\SQL_Query.sql -o c:\CSV_Output.csv -s”,”

And my sql script:

SELECT * FROM dbo.pay

The file with this error message:

Msg 208, Level 16, State 1, Server DEVSERVER\SQLEXPRESS, Line 1
Invalid object name 'dbo.pay'.

Xavi Martínez · Accepted Answer · 2021-04-19 15:44:33Z

3

Specify database name.

sqlcmd -S [sql server name] –d [database name] –U [user name] –P [password] –Q "your sql query" –s "," –o "D:\demo.csv"

edited Apr 19, 2021 at 15:44

Xavi Martínez

2,1611 gold badge17 silver badges18 bronze badges

answered May 25, 2015 at 3:50

Imran Saddapalli

875 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Lee Over a year ago

sqlcmd -S DEVSERVER\SQLEXPRESS –d AWP_WWW –U dbadmin –P Admin123$ –Q ”SELECT * FROM dbo.pay –s “,” –o “C:\export-sql-server-to-csv\output.txt”

Lee Over a year ago

this is my command line, when i execute it it shows "Unexpected Arguement" in cmd. Need help thx.

Imran Saddapalli Over a year ago

Can you try with file name output.CSV?

Imran Saddapalli Over a year ago

It is because of double quotes(copy & paste). Can you type the double quotes manually and try?

Lee Over a year ago

Thanks Imran, i typed the double quotes manually and i able to fixed the problem. But when i add " WHERE st_code='abc' , 'abc1' ; " statement, it appears the same problem again.

|

Collectives™ on Stack Overflow

Scheduled SQL Server Data Export to CSV using SQLCMD

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related