Hi All,
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 - 3 80053
The location of the file is relative to the SQL Server on which the BULK
INSERT command runs. To import a file from another machine, specify an UNC
path rather than use drive letters. For example:
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" <vo******@hotmail.com> wrote in message
news:af**************************@posting.google.c om... Hi All,
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 -
Hi Dan,
Thanks for your reply.
It does not work yet.
A next question:
SQL Server service account needs permissions to the share.
In my case SQL server is setup following:
In the security tab: Authentication - SQL server and windows.
Startup sevice account - system account.
Can somebody give me any hints
Regards
- Loi -
"Dan Guzman" <da*******@nospam-earthlink.net> wrote in message news:<la*******************@newsread1.news.pas.ear thlink.net>... The location of the file is relative to the SQL Server on which the BULK INSERT command runs. To import a file from another machine, specify an UNC path rather than use drive letters. For example:
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" <vo******@hotmail.com> wrote in message news:af**************************@posting.google.c om... Hi All,
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 -
> Startup sevice account - system account.
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" <lo********@fnh.no> wrote in message
news:73**************************@posting.google.c om... Hi Dan, Thanks for your reply. It does not work yet. A next question: SQL Server service account needs permissions to the share. In my case SQL server is setup following: In the security tab: Authentication - SQL server and windows. Startup sevice account - system account. Can somebody give me any hints
Regards - Loi -
"Dan Guzman" <da*******@nospam-earthlink.net> wrote in message
news:<la*******************@newsread1.news.pas.ear thlink.net>... The location of the file is relative to the SQL Server on which the BULK INSERT command runs. To import a file from another machine, specify an
UNC path rather than use drive letters. For example:
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" <vo******@hotmail.com> wrote in message news:af**************************@posting.google.c om... Hi All,
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 - This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: VMI |
last post by:
When I try to run my Windows application in another PC, I get the error:
Microsoft.Data.Odbc.OdbcException: ERROR Specified driver could not
be loaded due to system error 126 (SYBASE SYSTEM...
|
by: Brad |
last post by:
I will also post this in the CR group but because I program in VB maybe
somebody here might be able to help.
I am working on a new project that incorporates a few forms. I just created
my first...
|
by: Bob |
last post by:
Just thought I'd share my experience today with this error message. I
received it when doing an .update on a recordset .add. The fieldname
that the error message included wasn't even in the table...
|
by: hypermommy |
last post by:
Hi all,
I have a problem that's got me just stumped. On my local machine
(WinXPPro) my application runs just fine. But on the client's server
(Win2003ServerStandard) when I try to pull up my...
|
by: Chandra Mohan |
last post by:
how do I get error codes like 404 - access error, 502 - bad gateway.. 505 etc
programatically from the exception?
WebException has a status field which gives generic error tag like
protocolerror....
|
by: marty.gagnon |
last post by:
I have a xsl file that references a xml file using the document()
function.
I'm having trouble specifying the URI in the document() function of a
xls stylesheet.
I'm using java to transform the...
|
by: Holger.Rostalski |
last post by:
hello
i have an very old code here, wich worked long time very well.
but now i 've got a bugreport that there is a problem with "nan" for
delta_sigma.
in my code is a very long math-calculation...
|
by: Seriph |
last post by:
Hey
I just installed Textpad ver 4.something and writen up a simple println program, but I cant compile it. I keep getting the message "cannot find the file specified" with...
|
by: Gilles Ganault |
last post by:
Hello
I'm trying to use urllib to download web pages with the GET method,
but Python 2.5.1 on Windows turns the URL into something funny:
========
url = "amazon.fr/search/index.php?url=search"
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |