Re: can not bulk insert a network file onto a remote SQL server 2005

I have this same exact problem, and have been fighting it for three
days. Even when I remove the lines that it says are causing the
problem, when I run it again, it just picks some new lines to fail on.

Check out this thread, where someone posts how they proved that the
problem only exists when using SQL Server 2005 to import the data:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=141512&SiteID=1

I'm convinced there is some kind of bug here, and I'm about to give up
on trying to use bulk insert altogether and just write a program to
import the file myself. SQL 2000 DTS can import the same file with no
problem. It's pretty clear there's nothing wrong with the file.

FYI, in an SSIS context, this same exact thing happens when using the
Bulk Insert task and when using the Import Column in a data flow task.
I can reproduce the problem by executing a BULK insert command in a
query window, taking SSIS out of the picture altogether.

If anyone from Microsoft is reading this and is aware of this issue,
please advise. There are clearly multiple people out here fighting it.

Dan

Kiran wrote:
> I can not bulk insert a network file onto a remote SQL server 2005 machine
>
> I get this error when run from Query analyser in remote machine
> Cannot bulk load because the file <File Name> could not be opened. Operating
> system error code 5(Access is denied.)
>
> It used to work in SQL 2000 We just upgradted to SQL 2005.
> The same command works fine when run from the local machine hosting the SQL
> server it can access the remote file and can bulk isert but when run from
> remote machine it does not work. All accounts are admin accounts and we use
> Windows authentication and are using valid UNC paths.
> 
> Thanks
> Kiran

.

Relevant Pages

  • Re: Fix of problem connecting VS2005 to remote Sql 2000 server
    ... The remote machine is an sbs 2000 machine (win2k server, isa 2k, sql ... using and figure out why it's not working, in the case of tcp at least. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Cannot fetch a row from OLE DB provider "BULK" for linked serv
    ... Bulk load: An unexpected end of file was encountered in the data file. ... Anyway, there was an error in the format file, at least in regards to ... This is probably when you need to look at SQL Server Integration Services, ...
    (microsoft.public.sqlserver.programming)
  • Re: Use a sequence to bulk collect into a collection?
    ... Patrick Demets wrote: ... And this cursor returns one record. ... FETCH ew_eqmt_asgn_csr BULK COLLECT INTO ... SQL> create sequence testseq; ...
    (comp.databases.oracle.server)
  • Bulk Insert with LINQ to SQL
    ... I am using a combination of LINQ to SQL and bulk insert. ... One problem I am having is trying to use a 'transaction' to wrap ...
    (comp.databases.ms-sqlserver)
  • Re: Bulk insert ArrayList into table
    ... SqlBulkCopy is probably perfect for you described ... There is no faster way to insert data into SQL ... Server than a bulk insert technique. ... @ExtremeDate datetime, ...
    (microsoft.public.sqlserver.programming)