Transfer Sponsorship is only needed if you want to move to new company directly at the time you resign.

In your case, as long you have NOC, the new company will give you new sponsorhip, new ID, RP, no need 'Transfer Sponsorship' letter anymore