Sounds like your actuator is shot. You can buy the part at Pelican Parts. If you look around, there are some DIY FAQ's for this job. I had to change mine out this winter. Not much fun, pretty time consuming, but not all that difficult.
1997 328I Sport Package