You cannot update a table using the OLE DB Destination.

You need to use the OLE DB Command for that. However, this component will update the table row by row, so it is extremely slow.

You better write the rows to a staging table and then use an Execute SQL Task to issue an UPDATE statement.