I was trying to insert data from variable into database via SSIS, I made use of Execute XML Task, below is the screenshot,
and also created the stored procedure in my sql server to insert data and Data is my user variable which stores the result in xml file format from web service task, but this SQL EXECUTE Task is not executing
this is parameter mapping page
Even if I replace the sql statement by query as "insert into dbo.Data_Result(Result) values('1')" and remove the mapping parameter still it shows the error in execution.
不...任务没有触发,它实际上没有显示任何错误...很抱歉解释错误,我的 Web 服务任务已成功执行,但执行 XML 任务未执行。
Below is my flow
In web service task I have used my simple web service to add the numbers and returns the data in variable, that variable I have to use in Execute XML Task to enter that added result in sql Database.
在“参数映射”窗口中,“参数名称”需要包含一个从零开始的整数值,而不是存储过程中定义的参数名称。该整数值映射到 SqlStatement 属性中的问号。
您有一个要映射的参数,因此您应该在参数名称中使用值零。使用的整数值应映射到该参数在存储过程调用中出现的位置。
例如,如果向存储过程添加第二个参数,则首先应向 SqlStatement 属性添加另一个问号,然后在映射屏幕中添加第二个参数,参数名称值为 1。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)