Raunch, can you clarify if you're trying to make an animated texture or if you're trying to bring in source video footage for reference to build a scene? For example, if you're modeling a tv, you can map an animated texture to the screen as pure_morning suggested.

On the other hand, if you're trying to bring in reference footage to build your models to, you would more-than-likely use Maya live (if you have 4.5 unlimited) or other matchmoving software.