Databases
StackOverflow2013
Postsdbo
POWriting XML data from URL to Object in SSIS Script Task
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWriting XML data from URL to Object in SSIS Script Task
    text
    copied!<p>I have this URL where there is XML data. I have to extract that data from URL and dump it into DW table. I am using SSIS Script Task for that.</p> <p>This is how the data looks like:</p> <p><code>-&lt;currency&gt;</code></p> <pre><code>&lt;csymbol&gt;AED&lt;/csymbol&gt; &lt;cname&gt;United Arab Emirates Dirhams&lt;/cname&gt; &lt;crate&gt;3.6732001305&lt;/crate&gt; &lt;cinverse&gt;0.2722421770&lt;/cinverse&gt; </code></pre> <p><code>&lt;/currency&gt;</code></p> <p><code>−&lt;currency&gt;</code></p> <pre><code>&lt;csymbol&gt;AFN&lt;/csymbol&gt; &lt;cname&gt;Afghanistan Afghanis&lt;/cname&gt; &lt;crate&gt;44.0000000000&lt;/crate&gt; &lt;cinverse&gt;0.0227272727&lt;/cinverse&gt; </code></pre> <p><code>&lt;/currency&gt;</code></p> <p><code>−&lt;currency&gt;</code></p> <pre><code>&lt;csymbol&gt;ALL&lt;/csymbol&gt; &lt;cname&gt;Albania Leke&lt;/cname&gt; &lt;crate&gt;104.4100000001&lt;/crate&gt; &lt;cinverse&gt;0.0095776267&lt;/cinverse&gt; </code></pre> <p><code>&lt;/currency&gt;</code></p> <p>This is the code i'm using to load it into some Object type or something. But i dont know how to do that.</p> <pre><code>public void Main() { String URLString = "http://www.xe.com/dfs/datafeed2.cgi?beeline"; XmlDocument doc = new XmlDocument(); XmlTextReader reader = new XmlTextReader(URLString); doc.Load(reader); XmlNodeList currencynodes = doc.SelectNodes("currency"); foreach(XmlNode currency in currencynodes) { XmlNode csymbol = currency.SelectSingleNode("csymbol"); string csymbolvalue = csymbol.Value; XmlNode cname = currency.SelectSingleNode("cname"); string cnamevalue = cname.Value; XmlNode crate = currency.SelectSingleNode("crate"); string cratevalue = crate.Value; XmlNode cinverse = currency.SelectSingleNode("cinverse"); string cinversevalue = cinverse.Value; Dts.Variables["User::oCurrencyConversion"].Value = csymbol.Value; } </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload