I recently fixed this problem on my car.

The rubber sunroof drain hose had perished behind the headliner at the top of the A pillar.
Water was draining over the upper trim panel, down the A pillar trim, and ultimately behind the dash onto the carpet.

There was also some mild corrosion on the drain tube which didnt help things.

Cheers,
Ben.