Almost a sure bet you've lost one of your shift solenoids (2nd and 4th). Common problem, not too bad to fix but you do have to drop the pan and the valve body. GM sells a kit with the updated solenoids and improved bracket.
Here's a how-to with pictures: http://www.cadillacforums.com/forum...85-code-p094-shift-solenoid-speed-sensor.html
It should have set a code, have you looked at what codes were stored?
Here's a how-to with pictures: http://www.cadillacforums.com/forum...85-code-p094-shift-solenoid-speed-sensor.html
It should have set a code, have you looked at what codes were stored?