Noisy a904

What makes you think it's coming from the transmission? Have you put it up on a lift and ran it through the gears and listened to it? If not do so to determine positively where the noise is orginating. A trans. doing what you say would be extremely rare but there are several other things that can do what you describe.