huda12
asked on
BCP errors
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.
Thank you
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.
Thank you
Post few lines of you text
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.