BULK Insert Problem

From: Prabhat (not_a_mail_at_hotmail.com)
Date: 05/03/04 

Date: Mon, 3 May 2004 12:49:43 +0530

Hi All,

I work in a Network Environment. My System Number is "system1" where the SQL
Server DB is Installed. And If I Try to Bulk Insert any thing from my system
Then it works fine.

But If I Try to do Any BULK INsert from "system2" then I Get the below
ERROR!!!!

Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because file '\\radsoftech-115\MSF\Import\Jules
Kuperberg NY List 1 12-18-03.csv' could not be opened. Operating system
error code 5(Access is denied.).

My SQL Statement to FROM_ACQ table is Like:

BULK INSERT FROM_ACQ
 FROM '\\usert2\Import\NY_List.csv'
 WITH (FIRSTROW = 2, FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')

Even I CAN Open that file of system2 from my system using "Start - RUN". My
SQL Server Startup is Done in ADMINISTRATOR Account, and Same with System2
also. Both the systems are having same possword for the user Administraotr.
Owner of the DB is User1\Administrator.

So where is the problem? Any Help.

Thanks in Advance.
Prabhat

Relevant Pages

  • Re: VBA - Create a recordset with no records for inserting
    ... directly into the server, I can run a PROC that gets files from my desktop. ... The ServiceBroker will construct the dynamic SQL statement to BULK INSERT the ...
    (microsoft.public.data.ado)
  • ANN: CsvReader 2.0 Released
    ... One of the most common tasks involving CSV data in a Microsoft ... environment is to bulk insert data originating from a CSV file into SQL ... another datasource directly into SQL Server at almost DTS speeds. ...
    (microsoft.public.dotnet.general)
  • Re: Ignoring duplicates in BULK INSERT with ADO and SQL Server 200
    ... I am using bulk insert to transfer hugh data from a .dbf file to my sql ... from SQL Server. ... Because for SQL Server to do BULK INSERT that is what it demands. ...
    (microsoft.public.data.ado)
  • Import mit Bulk Insert Probleme mit Umlauten
    ... Ich bin mit meiner Applikation von SQL 2000 Server auf SQL 2005 Server ... Jetzt habe ich mit den Bulk Inserts mein Problem ... In der zu importierenden Textdatei stehen die Umlaute korrekt ...
    (microsoft.public.de.sqlserver)
  • Need macro to drag values down to blank cells
    ... I have a spreadsheet that I use to upload data to a SQL ... Server using bulk insert. ...
    (microsoft.public.excel.programming)
Loading