通过XML任务与SSIS进行数据转换 [英] Conversion of Data through XML task vis SSIS

问题描述

我已经使用了简单的Web服务来添加数字，并以以下格式的变量返回结果

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>

因此，当我尝试通过Execute SQL Task将35插入数据库时​​，上面给出的所有xml内容都插入到数据库中，因此我在Web服务任务和Execute SQL Task之间使用了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.

这篇关于通过XML任务与SSIS进行数据转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！