What version of Maya are you running?

I believe you'll need to check "Use Image Sequence" and the keyframe the Image Number box to play the video.

Later versions of Maya made the process a bit easier.