The Black Cats reach play off final as a stoppage time equaliser from Patrick Roberts sends Sunderland to Wembley.
Lee Gregory had given Wednesday the lead on the night, which dragged the aggregate score level, but it was Sunderland who had the final say.
Alex Neil named an unchanged side from the team on Friday which gave Sunderland a one goal advantage going into the 2nd leg, for the first time during his reign.
Both teams had their moments in what was an evenly matched, nervy affair and it ended in delight for Sunderland who will go on to face Wycombe Wanderers in the final.
The first half chance came for Sunderland in the 25th minute as Danny Batth headed high from an Alex Pritchard free kick.
Wednesday grew into the half and in the 35th George Byers had an acrobatic effort from the centre of the box routinely saved by Patterson.
The half time whistle came, and the tie was far from over as neither team were able to take control of the game and put the other under pressure, which resulted in a cagey first half.
In the second half Sunderland came out the stronger as Jack Clarke went on a run from his own half teeing up Roberts who hit a shot straight at the goalkeeper form the edge of the area.
With a bumper crowd at Hillsborough, Wednesday heaped pressure on Sunderland eventually breaking the deadlock, Barry Bannan unlocked the Sunderland defence and winger Marvin Johnson played the ball across the Sunderland area for Gregory to draw the owl’s level on aggregate heading into the final 15 minutes.
Sunderland responded by grabbing a late winner in the 93rd minute when Clarke latched onto a long ball down the Sunderland left hand side and he flashed the ball across the box to Roberts who fired home from close range sending the Black Cats to Wembley.