It would seem that Scotch Guard would make the individual fibers hydrophobic, which would keep them from wetting, which would keep the water out by means of its own surface tension.

Here's an interesting how-to: http://www.ehow.com/how_5931315_waterproof-nylon-jacket.html
I wonder how much a good result depends on the heating step...

-Rodney