[freetds] Having trouble doing a BULK INSERT

Wes Gamble weyus at att.net
Mon Nov 6 11:50:02 EST 2006


All,

Mandriva Linux 10.x
freetds 0.64

I'm attempting to perform a BULK INSERT into a SQL Server table.
I created a table named "westest" with one column in it, that's a char(10).

The output that I get when I attempt to BULK INSERT a valid file that 
exists in the local directory is below - it's saying that the file 
doesn't exist.  However, this file exists in the local directory with 
permissions set to 666. 

Is there something I'm missing here - does freetds support the use of 
BULK INSERT?

Thanks,
Wes

================= Output of test ====================

[dusan at exmit2 lists]$ tsql -H DBServe -p 1433 -U webuser -P webusercb
locale is "en_US"
locale charset is "ISO-8859-1"
1> BULK INSERT dbo.westest FROM 'data'
2> go
Msg 4860, Level 16, State 1, Server DBSERVE, Line 1
Could not bulk insert. File 'data' does not exist.
1>

===============  Data file ===========================

[dusan at exmit2 lists]$ cat data
jsdf
lkajdsf
lkajdf
lkajdsf
lkajf
wpoieur
oiwur
wer





More information about the FreeTDS mailing list