Are you sure it is from the transmission? When ignition switch is turned off, there should be no power supply to the transmission solenoids and there are nothing that can cause clicking noise there. How does the noise sound like and its interval?