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

Jiroju 1 Reputation point
2021-03-18T09:22:42.523+00:00

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2021-03-19T02:07:13.593+00:00

    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:
    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.