Hi @Sofian ,
Found a similar thread like your issue and someone provided two methods.
1.Use an OLEDB Command component within the data flow. The downside is this calls the statement for each record, so if you have 1,000s of records it is very inefficient.
2.Push the records to a table using an OLE DB Destination and then you can call your update using an Execute SQL Task.
Details for your reference:https://stackoverflow.com/questions/4475508/ssis-want-to-update-a-sql-table-based-on-a-flat-file
You may also refer below blog to insert and update rows in a table based on the contents of a Excel file.
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.
Hot issues October