Bulk insert Error

1 Sep 2005 10:58 PM

vineetbatta

i am firing the following from QA

bulk insert pubs.dbo.Orders from '\\<ServerName>\test\Orders.txt'
with (DATAFILETYPE = 'native')

This <ServerName> is not the servername of the SQL Box, but the remote box
where i have created the shared folder test with approrite permissions.

But i keep getting the following error
Could not bulk insert because file '\\<ServerName>\test\Orders.txt' could
not be opened. Operating system error code 5(Access is denied.).

is it supported with BULK INSERT.

--
MCAD
Vineet Batta

2 Sep 2005 12:05 AM

S

Ye, its possible. Be sure to specify UNC path names when the file is on a
remote server. I have tried it and it works for me when it has correct
permissions. GoodLuck

Show quote

"vineetbatta" wrote:

> i am firing the following from QA
>
>
> bulk insert pubs.dbo.Orders from '\\<ServerName>\test\Orders.txt'
> with (DATAFILETYPE = 'native')
>
> This <ServerName> is not the servername of the SQL Box, but the remote box
> where i have created the shared folder test with approrite permissions.
>
> But i keep getting the following error
> Could not bulk insert because file '\\<ServerName>\test\Orders.txt' could
> not be opened. Operating system error code 5(Access is denied.).
>
>
> is it supported with BULK INSERT.
>
> --
> MCAD
> Vineet Batta
>