You should get a certain amount of compression if you use a typed xml column i.e. define a schema for your xml.

It won't be very compressed, but better than nothing. However the xml in output will be equivalent but slightly different (in terms of whitespace and certain other differences.)

Otherwise for real compression which conserves the file as was, you'll have to do it in c# (it seems to me.)

Hope this helps,

David.