bcp issues with the cmd running returning nothing

Viewed 28

I have a batch file but it is not running and giving me no error but doing nothing

bcp [AcademicDbo].[dbo].[AccCriteriaDummy] out c:\temp\csvdump\dbo_AccCriteriaDummy.csv -Usa -Pqwerty -C 65001 -t "|" -k -c -S localhost

enter image description here

it seems working but the problem I am having is:

Error = [Microsoft][ODBC Driver 17 for SQL Server]Warning: BCP import with a format file will convert empty strings in delimited columns to NULL.

I want to show along the headers and the data, but how can I get headers

I am not sure what is going wrong with it, but it should work.

0 Answers
Related