2012年2月25日星期六

bcp bulk upload

Hello !!

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

EG.

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 helpyou 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).

没有评论:

发表评论