Error on Executing Sql Task in SSIS

问题:

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.

No...task does not fire, it doesnot show any errors actually..sorry for wrong explanation, my web service task executes successfully but Execute XML Task does not executes.

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.

回答1:

Within the Parameter Mapping window, the Parameter Name needs to contain an integer value, starting with zero, not the name of the parameter as defined in the stored procedure. This integer value maps to the question mark in the SqlStatement property.

You have one parameter to map, so you should use the value zero in the Parameter Name. The integer value used should map to the position that that parameter appears in the call to the stored procedure.

For example, if you add a second parameter to the stored procedure, you would first add another question mark to the SqlStatement property and then add a second parameter in the mapping screen with a value of 1 for the Parameter name.