This article will show the most common way to resolve the Upsert Destination hanging during execution
If you have a package hang on the Upsert Destination, like this
The most likely cause of this issue is a table lock has occurred on the destination table your package is attempting to write. To resolve this issue, we must turn off Table Lock, similar to the native OLE DB Destination.
To resolve this issue, open the Upsert Destination editor and navigate to the Advanced tab. Here, tick the ‘Turn off internal transactions’ box.