These guys think any transmission off a ka24 will work.
what-year-transmission-will-fit-in-a-95 ... 32109.html
Sounds true to me. Input shaft and bellhousing should fit. You Might have to swap the adapter and reuse your driveshaft. I have never tried this on a Nissan, but if these forum members can put a frontier transmission in a 240sx, you can certainly put a sx transmission into a pickup.