通过 XML 任务与 SSIS 进行数据转换
我使用了简单的网络服务来进行数字加法，并将结果返回到变量中，格式如下
I have consumed simple web service for addition of numbers and returns the result in variable which is in the following format
<?xml version="1.0" encoding="utf-16"?>
<int>35</int>
所以当我尝试通过执行 SQL 任务将这个 35 插入数据库时，上面给出的整个 xml 内容都插入到数据库中，所以我在 Web 服务任务和执行 SQL 任务之间使用了 XML Tsk，它的屏幕截图是如下，
So when I try to insert this 35 into database through Execute SQL Task then whole of the xml content given above is inserted into database, so I used XML Tsk in between web service task and Execute SQL Task, it's screen shot is as follows,
仍然无法得到35的节点值插入数据库.
Still it is not able to get the node value that is 35 to insert it into database.
推荐答案
您必须将 'SecondOperand' 值更改为//int
You must change the 'SecondOperand' value to //int
如果要保存结果，请配置OperationResult"属性.
If you want to save the result, configure 'OperationResult' properties.
相关文章