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

Jiroju 1 Reputation point

I try to update cell in excel by execute sql task


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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points

    Hi @Jiroju ,

    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:

    Best regards,

    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.