Topic: Re: remote SP to shred local XML file

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/27/2008 10:22:57 PM

By: PT

"JOH" <JOHolloway@gmail.com> wrote in message
news:d3e1f88f-3335-49de-aa95-282b28aacf02@x41g2000hsb.googlegroups.com...
> On May 27, 6:30 pm, JOH <JOHollo...@gmail.com> wrote:
>> SQL Server 2005
>>
>> I have an XML file and I'm using a stored procedure to shred it into
>> tables. Works perfectly so long as the file is on the server.
>>
>> What I want to do is have an Excel file with VBA call the procedure on
>> a remote SQL Server, and have the procedure read the XML file that is
>> stored locally. When I run this locally on a given server, it works.
>>
>> I have the XML file in a directory, shared, wide-open permissions.
>> When I try to run the procedure from the remote SQL Server, to come
>> back to my PC and pick up the XML file, I get an error indicating
>> permission denied.
>> Cannot bulk load because the file "\\myDesktop\myShare\sample.xml"
>> could not be opened. Operating system error code 5(Access is denied.).
>>
>> I am sysadmin on the remote server, and the file resides on my own
>> desktop. I've seen this issue in other postings, but no resolution so
>> far as I can tell.
>>
>> Is there a way that I can pass the XML file as an argument over to the
>> procedure?
>>
>> Any help would be much appreciated.
>
> I should have been more specific: I am sysadmin, via my Windows
> account.

Does the SQL Server service accout have access to that share?

Replies below ↓

Replies

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/27/2008 10:22:57 PM

By: PT

Re: remote SP to shred local XML file

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/27/2008 10:22:57 PM

By: PT

Re: remote SP to shred local XML file

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/28/2008 3:37:42 AM

By: JOH

remote SP to shred local XML file

SQL Server 2005

I have an XML file and I'm using a stored procedure to shred it into
tables. Works perfectly so long as the file is on the server.

What I want to do is have an Excel file with VBA call the procedure on
a remote SQL Server, and have the procedure read the XML file that is
stored locally. When I run this locally on a given server, it works.

I have the XML file in a directory, shared, wide-open permissions.
When I try to run the procedure from the remote SQL Server, to come
back to my PC and pick up the XML file, I get an error indicating
permission denied.
Cannot bulk load because the file "\\myDesktop\myShare\sample.xml"
could not be opened. Operating system error code 5(Access is denied.).

I am sysadmin on the remote server, and the file resides on my own
desktop. I've seen this issue in other postings, but no resolution so
far as I can tell.

Is there a way that I can pass the XML file as an argument over to the
procedure?

Any help would be much appreciated.

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/28/2008 3:37:42 AM

By: JOH

remote SP to shred local XML file

Page 1 of 3 Pages