Update,

BMW dealership said they could shoot air through the line for $250 but said it might not work. The other option would be to replace the hose which they said would cost---get this---$2,400 because they would need to partially move the tranny to get to the hose underneath the car. Well--now way.

So-i got some weed whacker line and did push it down about 2 feet untill I hit a blockage. To make sure this was not a bend or something, i fed the line through the other side, drivers side, and i went much further. I also notcied that the weed whacker line was wet at the lower six inches for the problem side. In addition there was a bit of dirt on the end of the line. I tried to dig at the blockage with the weed whacker line but it simply is not strong enough and bends, I need something tougher i can feed down and attempt to push out what maybe be a large seed, pine needles, or something else. I'll try some large vynil wire or a light weight metal wire. I dont think it's a disconnected line from the sunroof as the water is in the line and there is some kind of blockage at a point.

Any other ides in the meantime?