I try to transfert data table from one server to another one by using BCP.
The 2 servers are running SQLS2k sp3.
The outpout work fine, but the input (option: -m2 -N) in destination DB return a message:
Starting copy...
SQLState = 37000, NativeError = 156
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Order'.
SQLState = 37000, NativeError = 156
Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'Order'.
i guess that i have the keyword "order" in my .bcp file so that disturb the input command.
How can i manage this ?
PS: i tried already the -w option for out-in command
Many thanks.Can you put in your bcp statement here? -T&R, Suresh.|||here after my BCP statement:
bcp.exe "Production.dbo.[Backup_Ordersdetail]" In "C:\...\bcpfiles\Backup_Ordersdetail.bcp" -m2 -N -Sxxxxxxx -Uxx -Pxxxxxxx
没有评论:
发表评论