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

BULK INSERT does support UNC file access across the network. The "Access is
denied." error looks like a Windows file permissions problem. Are you sure
that the SQL Server service account has permissions to access the share?

--
--Brian
(Please reply to the newsgroups only.)


"vineetbatta" <vineetbatta (AT) discussions (DOT) microsoft.com> wrote