I have sqlserver database,and have to update this table with daily report.txt file. i am using bcp tool to append the table, i ame having problome. the command is
bcp master.dbo.pop IN C:\log_task.txt -c -T -r -U -P
and the error is :
sqlstate= s1000, nativeError. ODBC sql server Diriver unexpected EOF encountered in bcp data file.
is bcp is the best tool to be used or there are alternative procedure that can be ran from sql Server itself.