I have some old termite damage to the end of a 2x12 floor joist. One end is sitting on a metal beam running along the centerline of my two story house (that sits on the foundation walls). The other end is sitting on the sill plate. No termite damage to sill plate, a small bit on the rim joist, but the end of the floor joist is basically eaten through for about 2 inches horizontally. So solution is to sister a new 2x12 joist, correct? Do I need to sister a full 16 foot joist, or can I get away with an 8 foot or 10 foot span (due to limitations in my vehicle capacity...). Plan is to apply 1-2 tubes of PL premium, knock sister into place and fasten with three 3" #10 screws on vertical lines every 12". For the rim joist, figured I can just install a piece of blocking over the sill plate, essentially sistering that part of the rim joist?
Photos added. Ignore the spray foam to keep pests out. Obviously not a solution.