Advertisement

05.19.2008 at 05:15AM PDT, ID: 23413383 | Points: 500
[x]
Attachment Details

Could not bulk insert (Operating system error code 53)

Asked by Venkatkp007 in MS SQL Server, MySQL

Hi!
I run a Bulk Insert Query on SQL Server 2000, the server is on different location.

Now the issue is, when ever we try to Upload a Bulk Data through a Text Document,
we get the following Error.(The locations folder is given full rights for Everyone)
Error: Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because file '\\xyz\G:\wwwroot\AE_50\PE2\locations\location314052008133342.txt' could not be opened. Operating system error code 53(error not found).

The Following Query is Used for Bulk Insert
BULK INSERT Temp_Locations FROM '\\xyz\G:\wwwroot\AE_50\PE2\locations\location314052008133342.txt' WITH (FIELDTERMINATOR = '      ',ROWTERMINATOR = '\n')


 Start Free Trial
 
Keywords: Could not bulk insert (Operating syste…
Title
1 RowTerminator
2 Using Bulk Insert from Text File without…
3 BULK INSERT comma delimited file -- …
4 FIELDTERMINATOR
5 SQL Server 2000 Bulk Insert Problem
6 BULK INSERT
 
Loading Advertisement...
 
[+][-]05.19.2008 at 05:32AM PDT, ID: 21597149

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 05:33AM PDT, ID: 21597158

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.19.2008 at 06:09AM PDT, ID: 21597432

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.21.2008 at 11:10PM PDT, ID: 21621316

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.22.2008 at 12:12AM PDT, ID: 21621525

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628