use XmlDataDocument load from an URL with username password

[Alcibiades]

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?

[fallenidol]

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)
--
"If ignorance is bliss, then wipe the smile from my face."
"Al********@gmail.com" wrote:

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?