question

Jiroju-1599 avatar image
0 Votes"
Jiroju-1599 asked Monalv-msft edited

SSIS - How to update value in cell of excel by Execute SQL Task

I try to update cell in excel by execute sql task


79133-reportweekly.png

but I got this error

![Execute SQL Task] Error: Executing the query "update [ReportWeekly$I1:I1] set F1 = ?" failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.][1]


sql-server-integration-services
reportweekly.png (17.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @Jiroju-1599 ,

1.Please check if you set the parameter correctly in the Parameter Mapping page.

2.update [ReportWeekly$I1:I1] set F1 = ?
Could you please share the example of your Excel Data?
F1 should be within the range of ExcelSheet.
Please extend the range of the Excel worksheet.

3.Please refer to the following example:
79407-exceldatabefore.png
79408-est1.png
79374-est2.png
79416-cf-variable.png
79409-exceldataafter.png

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.





est1.png (27.9 KiB)
est2.png (13.7 KiB)
cf-variable.png (31.6 KiB)
exceldataafter.png (8.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Jiroju-1599 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·