var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: bcp/bulk insert question
I have a table with 3 columns
name1 name2 number
csv file has the data like the following
Dave Chris,"Ken, David", 1234
--- BCP Command
declare @sql varchar (4000)
set @sql='exec master..xp_cmdshell ''bcp "test.dbo.testdata" in "c:\test.csv" -T -c -q -t,'''
Getting this error
Error=[Microsoft][SQL Native Client] Unable to open BCP host data-file Null
Any feedback is greatly appreciated !
This is most likely because you are executing the query in SSMS and the file should be on server c:\ and not on local machine. Or use the fully qualified domain name: "\\server\share$\test.csv"
Originally Posted by sskris
I got this message when the file is on my server c:\
1 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 16 Average : (62.50 rows per sec.)
Last edited by corncrowe; 01-20-11 at 05:09.