将 XML 数据从 URL 写入 SSIS 脚本任务中的对象 [英] Writing XML data from URL to Object in SSIS Script Task
本文介绍了将 XML 数据从 URL 写入 SSIS 脚本任务中的对象的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有这个包含 XML 数据的 URL.我必须从 URL 中提取该数据并将其转储到 DW 表中.我为此使用了 SSIS 脚本任务.
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.
这是数据的样子:
-<货币>
<csymbol>AED</csymbol>
<cname>United Arab Emirates Dirhams</cname>
<crate>3.6732001305</crate>
<cinverse>0.2722421770</cinverse>
−
<csymbol>AFN</csymbol>
<cname>Afghanistan Afghanis</cname>
<crate>44.0000000000</crate>
<cinverse>0.0227272727</cinverse>
−
<csymbol>ALL</csymbol>
<cname>Albania Leke</cname>
<crate>104.4100000001</crate>
<cinverse>0.0095776267</cinverse>
这是我用来将其加载到某种对象类型或其他类型的代码.但我不知道该怎么做.
This is the code i'm using to load it into some Object type or something. But i dont know how to do that.
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;
}
推荐答案
为此,您实际上需要在数据流任务中使用脚本源组件.然后使用标准的目标组件插入到 DW 中.
You actually need to use a Script Source Component inside of a dataflow task for this. Then use the standard destination compoents to do the insert into DW.
这是我实现的示例包.http://dl.dropbox.com/u/5332312/xRateLoader.zip
这篇关于将 XML 数据从 URL 写入 SSIS 脚本任务中的对象的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文