I use Bulk insert to put data to myTable.
When the SQL server is in local machin, it works well. But when I put
the data in a sql server situated not locally, then I get a error
message like this:
Could not bulk insert because file 'C:\Data\2003
txtfiles\abif_20031130.txt' could not be opened. Operating system
error code 3(The system cannot find the path specified.).
BULK INSERT myTable
FROM 'C:\Data\2003 txtfiles\abif_20031130.txt'
with (
-- codepage = ' + char(39) + 'ACP' + char(39) + ',
fieldterminator = ';',
rowterminator = '\n',
keepnulls,
maxerrors=0)
Someone can explan me what the error shows up
Thanks in advance
- Loi -
BULK INSERT myTable
FROM '\\MyOtherServer\MyShare\Data\2003 txtfiles\abif_20031130.txt'
Note that the SQL Server service account needs permissions to the share.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Loi" <vota...@hotmail.com> wrote in message
news:af9512d5.04060...@posting.google.com...
Regards
- Loi -
"Dan Guzman" <dang...@nospam-earthlink.net> wrote in message news:<laEvc.20183$Tn6....@newsread1.news.pas.earthlink.net>...
Try using a domain account rather than the local system account and ensure
the account has permissions to the share.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Loi Tan Vo" <loi.t...@fnh.no> wrote in message
news:73f04281.04060...@posting.google.com...