Rage fading.... fading....
Found this old post on the mentalray forum:
Luckily I only have 10 sprites, so wiring it wasn't too hard. Basically:
-add userScalar1PP
-particle expression,add 'userScalar1PP, = spriteNumPP/10' (ie, take the sprite num and bring it down to 0-1)
-make a file node for each frame in the sequence
-connect them all to a ramp, set interpolation to none
-make a particlesampler
-connect userScalar1PP to the vCoord of the ramp
-create a mult/divide node
-mult the ramp by particleSampler.rgbPP
-wire that to a shader
-do a similar dance for opacityPP
-dance
Works in mentalray and vray. Of course it doesn't work in the maya software renderer nor the viewport, but I don't need those anymore.
Thanks for making me waste a day on this maya!