none
SSIS UPDATE Excel sheet using OLEDB RRS feed

  • Question

  • tying to update single cell, 

    UPDATE [Sheet$A2:A2] SET Source=’test'


    [Execute SQL Task] Error: Executing the query " UPDATE [Sheet$A2:A2] SET Source=’test’" 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.

    how to resolve this.    I don't want to insert, 

    what i am doing is,  DataFlow, (Export to Excel),  i need to update single cell

    Tuesday, February 20, 2018 5:44 PM

All replies

  • You need to use Excel interop for that

    The logic would be written inside a script task by adding reference to interop

    see

    http://bidn.com/Blogs/updating-a-single-excel-cell-using-ssis


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Tuesday, February 20, 2018 5:56 PM
  • Hi Vaishu,

    Besides using Script Task, you can also try to use Execute SQL Task to update Excel file.

    1. Create Excel connection to your file.

    2. Get the Execute SQL Task in control flow, then in connection select Excel and write your query like below:

    Update [Sheet1$]

    Set ColumnName="Updatevalue"

    WHERE IDColumn=1

    See: How to update edit or change the record in Excel                                

    Regards,

    Pirlo Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, February 21, 2018 3:59 PM
    Moderator