Results 1 to 2 of 2

Thread: bcp bulk upload

  1. #1
    Join Date
    Sep 2003

    Wink Unanswered: bcp bulk upload

    Hello !!

    Can anyone help, I am trying to do bulk upload:


    set @BULK = 'bcp "DQ_Central.dbo.tbl_CLI_UPLOAD" in "' + @file_path + '" -S' + @Server + ' -U' + @User + ' -P' + @PSW

    and am getting this output message

    Enter the file storage type of field service_number [char]:

    Any one have any ideas ?!? Thanks u for yr help

  2. #2
    Join Date
    Sep 2003
    you forgot to specify the input file type, - character or native (-c or -n).

    but you, you can do the same thing with bulk insert. this way you won't have to through your @BULK at xp_cmdshell and get completely frustrated with char(39).

Posting Permissions

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