It really depends on the SDD you buy, but I know the newer ones using 3D NAND are supposed to last a lot longer.
Also if its only being used for a Wii U, you're really only going to be reading from it most of the time. Writing is what really hurts an SSD's life.
EDIT:
Heres a link to the life...