insert xml file into remote SQL Server 2005?

From: Dabbler <znews24z@xxxxxxxxxxxx>
Date: Mon, 3 Mar 2008 00:30:13 +0000 (UTC)

I'm stumped as to how to insert data (shredded) from an XML file into a table's columns. I tried using bcp but get "not trusted connection" error (its a remote server so not using Windows Authentication). I don't think I can use bulk load with OPENROWSET because the datafile isn't on the server.

Any suggestions or links to samples would be appreciated.

Michael

.

Follow-Ups:
- Re: insert xml file into remote SQL Server 2005?
  - From: Mike C#

Prev by Date: Re: XQUERY big problem
Next by Date: Re: insert xml file into remote SQL Server 2005?
Previous by thread: Re: XQUERY big problem
Next by thread: Re: insert xml file into remote SQL Server 2005?
Index(es):
- Date
- Thread

Relevant Pages

RE: Programatically Build and Post Form
... Regardless of the former three items you mentioned below: ... Automatically send the XML file to a remote server as an HTTP POST ...
(microsoft.public.dotnet.general)
Programatically Build and Post Form
... Automatically send the XML file to a remote server as an HTTP POST ... The problem is how to take this string and stream it to the ...
(microsoft.public.dotnet.general)
Using .Net code to FTP from one server to another
... transforms the dataset into an XML file. ... I have the FTP site running ... on the remote server and security is all set. ...
(microsoft.public.dotnet.general)
RE: Using .Net code to FTP from one server to another
... > transforms the dataset into an XML file. ... I have the FTP site running ... > on the remote server and security is all set. ...
(microsoft.public.dotnet.general)
Re: Using .Net code to FTP from one server to another
... > transforms the dataset into an XML file. ... I have the FTP site running ... > on the remote server and security is all set. ...
(microsoft.public.dotnet.general)