Sunderland will play Wycombe in the League One play-off final after Patrick Roberts' stoppage-time goal at Sheffield Wednesday.
The Black Cats had led 1-0 from the first leg but Lee Gregory wiped out their advantage in the second half.
Wednesday then looked the more likely to go on and get a second but the Wearsiders caught them cold.
Jack Clarke escaped down the left and pulled the ball back for Roberts to crash a shot home.
After levelling the tie on aggregate, Wednesday still had time to try to find a second goal that would have sent the tie to extra time because of the 10 minutes of time added on because of Sam Hutchinson's head injury - but they could not fashion one more big chance.
They will now spend at least another campaign the third tier after being relegated from the Championship on the final day last season.
Sunderland's progress means that the play-off final will be contested by the teams who finished fifth and sixth in League One, after the Chairboy got past third-placed MK Dons.
Alex Neil will look to guide them to a victory at Wembley to end their four-year spell in League One after their successive relegations from the Premier League.
Wednesday had the better of a tetchy first half but the closest they came to a goal was when Anthony Patterson easily held George Byers' well-executed bicycle kick.
Roberts sent a shot straight at home goalkeeper Bailey Peacock-Farrell after an enterprising run from Clarke, before Gregory levelled the tie with a close-range finish after Barry Bannan's incisive pass had freed Marvin Johnson down the inside left and he cut back first time.
Thereafter it looked like the home side were the more likely to go on and find a second goal that would have taken them to Wembley.
However, Tottenham loanee Clarke got away down the left and pulled the ball back for the onrushing Roberts to convert and spark wild celebrations among the travelling fans.
More to follow.
Line-ups
Sheff Wed
Formation 3-4-1-2
1Peacock-Farrell
38Storey16Dean5Hutchinson
32Hunt14Byers21Luongo18Johnson
10Bannan
11Windass9Gregory
1Peacock-Farrell38Storey16DeanBooked at 77mins5HutchinsonSubstituted forPalmerat 70'minutes32HuntSubstituted forMendez-Laingat 71'minutes14ByersBooked at 24minsSubstituted forBerahinoat 90+5'minutes21Luongo18Johnson10BannanBooked at 27mins11WindassSubstituted forPatersonat 78'minutes9GregorySubstitutes
2Palmer13Paterson20Kamberi22Dunkley24Berahino28Wildsmith41Mendez-LaingSunderland
Formation 3-4-1-2
20Patterson
26Wright5Batth17Cirkin
11Gooch13O'Nien4Evans25Clarke
21Pritchard
77Roberts14Stewart
20Patterson26Wright5Batth17Cirkin11Gooch13O'Nien4Evans25ClarkeSubstituted forDoyleat 90+8'minutes21PritchardSubstituted forMateteat 90+7'minutesBooked at 90mins77RobertsSubstituted forBroadheadat 90+7'minutes14StewartBooked at 45minsSubstitutes
6Doyle8Embleton9Broadhead24Neil27Matete32Hume39HoffmannReferee:James LiningtonAttendance:32,978Live Text
Match ends, Sheffield Wednesday 1, Sunderland 1.
Second Half ends, Sheffield Wednesday 1, Sunderland 1.
Attempt blocked. Massimo Luongo (Sheffield Wednesday) left footed shot from the centre of the box is blocked. Assisted by Nathaniel Mendez-Laing.
Jay Matete (Sunderland) is shown the yellow card.
Offside, Sunderland. Ross Stewart tries a through ball, but Jay Matete is caught offside.
Substitution, Sunderland. Callum Doyle replaces Jack Clarke.
Substitution, Sunderland. Jay Matete replaces Alex Pritchard.
Substitution, Sunderland. Nathan Broadhead replaces Patrick Roberts.
Substitution, Sheffield Wednesday. Saido Berahino replaces George Byers.
Goal! Sheffield Wednesday 1, Sunderland 1. Patrick Roberts (Sunderland) left footed shot from very close range to the centre of the goal. Assisted by Jack Clarke.
Foul by Lee Gregory (Sheffield Wednesday).
Dennis Cirkin (Sunderland) wins a free kick in the defensive half.
Foul by Nathaniel Mendez-Laing (Sheffield Wednesday).
Ross Stewart (Sunderland) wins a free kick in the defensive half.
Attempt blocked. George Byers (Sheffield Wednesday) right footed shot from outside the box is blocked. Assisted by Lee Gregory.
Foul by Callum Paterson (Sheffield Wednesday).
Bailey Wright (Sunderland) wins a free kick in the defensive half.
George Byers (Sheffield Wednesday) wins a free kick in the defensive half.
Foul by Alex Pritchard (Sunderland).
Attempt missed. Alex Pritchard (Sunderland) left footed shot from the left side of the box misses to the left. Assisted by Ross Stewart with a headed pass.