use XmlDataDocument load from an URL with username password

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alcibiades@gmail.com - 17 Oct 2006 11:48 GMT

I have a piece of code to read a xml file from the web and put it into
a variable in SSIS, but i don't know how to get it if it's username and
password protected:

URL = "http://www.mysite.com/setup.xml"
xmlDoc = New XmlDataDocument
xmlDoc.Load(URL)

Anyone can help me?

Reply to this Message

fallenidol - 24 Oct 2006 16:04 GMT

you need to specify an XmlResovler and add the necessary credentials to it.

XmlUrlResolver oXmlUrlResolver = new XmlUrlResolver();
oXmlUrlResolver.Credentials = CredentialCache.DefaultCredentials;

URL = "http://www.mysite.com/setup.xml"
xmlDoc = New XmlDataDocument
xmlDoc.XmlResolver = oXmlUrlResolver
xmlDoc.Load(URL)

Signature

"If ignorance is bliss, then wipe the smile from my face."

> I have a piece of code to read a xml file from the web and put it into
> a variable in SSIS, but i don't know how to get it if it's username and
[quoted text clipped - 5 lines]
>
> Anyone can help me?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...