Results 1 to 4 of 4

Thread: BCP syntax

  1. #1
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144

    Unanswered: BCP syntax

    is there anything wrong with my syntax ?

    bcp AGENCY out E:\Spreadsheets\Agency.txt -c -Svicbranch1 -Usqlsvc -Pabc123


    Server: Msg 170, Level 15, State 1, Line 1
    Line 1: Incorrect syntax near '.'.

  2. #2
    Join Date
    Feb 2004
    Posts
    88
    I can't see anything obviously wrong.
    I always specify database.owner.table in the first parameter to bcp, though.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    BCP is run from a command line, rather than from Query Analyzer.

  4. #4
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    I would suggest fully qualifing the table eg. dbname.dbo.tablename

    Or the problem may be that the table you are trying to access is in a different database to the default database of the username you are using..

    Just a thoughy

Posting Permissions

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