Results 1 to 3 of 3

Thread: BCP IN trouble

  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Angry Unanswered: BCP IN trouble

    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.

  2. #2
    Join Date
    Sep 2003
    Location
    Mumbai, India
    Posts
    36

    Re: BCP IN trouble

    Can you put in your bcp statement here? -T&R, Suresh.

  3. #3
    Join Date
    Sep 2003
    Posts
    2
    here after my BCP statement:

    bcp.exe "Production.dbo.[Backup_Ordersdetail]" In "C:\...\bcpfiles\Backup_Ordersdetail.bcp" -m2 -N -Sxxxxxxx -Uxx -Pxxxxxxx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •