English 中文(简体)
改为 缩略语
原标题:To read Xml file from variable in XML Source in SSIS

我正在通过网络服务任务取得不同结果,如下图所示:

enter image description here

然后,我利用XML的任务去除多余的名称空间,并储存经过处理的结果,使可恢复性变数出现另一种变数,如下图所示。

“enterography

本文第二版是我的data.xslt 文档,有助于从我的XML档案中删除外名空间。

下面是我控制流动的整个结构,

enter image description here

在数据流动中,我利用XML来源读出我的可变性,并将数据输入数据库,下文是XML来源的筛选。

“enterography

在此,它给我留下了错误,因为XML来源无法读到数据,XMLDataVariable是空的,我想读到底值,用OLEDB Destination将数据输入数据库。

如果不把网络服务任务的结果保留成变量,那么,我可以指出,在XML文件中,外部文件如下是我的XML。 文件格式

<?xml version="1.0" encoding="utf-16"?>
 <Data xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Name xmlns="http://localhost">Rahul</Name>
  <BirthDate xmlns="http://localhost">1991-04-20T00:00:00</BirthDate>
 </Data>.

在应用SLT规则去除多余名称空间之后,我的XML档案将照此办理。

<?xml version="1.0" encoding="utf-8"?><Data><Name>Rahul</Name><BirthDate>1991-04-20T00:00:00</BirthDate></Data>

And please make note, I have to compulsorily add the XSLT rule to remove the extra namespace otherwise it does not create the XSD for further operation and also my project works well If I store result in XML file externally but I want to make use of variable for whole operation,

问题回答

在设计时间,确保你实际上在<条码>中具备一些内容。 顺便说一句,在你管理包裹时,你将装上变数,但在设计时,你的变数将是空洞的,因此,你所期望的XML只是要把任务交给我们处理。





相关问题
how to represent it in dtd?

I have two element action and guid. guid is a required field when action is add. but when action is del it will not appear in file. How to represent this in dtd ?

.Net application configuration add xml-data

I need to add xml-content to my application configuration file. Is there a way to add it directly to the appSettings section or do I need to implement a configSection? Is it possible to add the xml ...

XStream serializing collections

I have a class structure that I would like to serialize with Xstream. The root class contains a collection of other objects (of varying types). I would like to only serialize part of the objects that ...

MS Word splits words in its XML format

I have a Word 2003 document saved as a XML in WordProcessingML format. It contains few placeholders which will be dynamically replaced by an appropriate content. But, the problem is that Word ...

Merging an XML file with a list of changes

I have two XML files that are generated by another application I have no control over. The first is a settings file, and the second is a list of changes that should be applied to the first. Main ...

How do I check if a node has no siblings?

I have a org.w3c.dom.Node object. I would like to see if it has any other siblings. Here s what I have tried: Node sibling = node.getNextSibling(); if(sibling == null) return true; else ...

Ordering a hash to xml: Rails

I m building an xml document from a hash. The xml attributes need to be in order. How can this be accomplished? hash.to_xml

热门标签