JoWood have posted the E3 trailer on the official Stargate SG-1: The Alliance website. The movie is available in 3 formats (Quicktime, MediaPlayer and Real Player) and 2 versions Hi Quality and Low Quality, it's 2 minutes and 55 seconds long and includes a glimpse of the game-specific enemies, The Haaken.

You can find the trailer here: