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'.

Answer 1

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"