SQLState = S1000, NativeError = 0 Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in BCP data-file
I am getting this error while importing data from a csv file to SQL azure table. I am new to this technology. So I am trying it out with some small no of records. I have very few records in my csv file and my Azure database table is empty right now.
This is the structure of the table in SQL Azure:
Create Table BCP
Id int identity(1,1)
Constraint [pk_bcp] primMary key clustered([id] asc)
) on [primary]
records I am trying to insert are as follows
I am trying to achieve through command prompt. the command I am using is
C:\Users\Administrator>BCP TestTask.dbo.BCP In C:\Users\Administrator\Desktop\Example\BCP.csv
-P Welc@m#123 -E -h 'TABLOCK' -n -k
If someone knows the correct solution of it please help me out I had already tried many solution but that didn't work for me.
Your help will be appreciated.
It looks like you're new here. If you want to get involved, click one of these buttons!