With SQL CLR you can build something more elegant if you truly wanted to be able to write files through your data engine. However, I think this type of activity belongs in your app-tier.

Also, at first glance it seems you're limited to writing files that contain only ascii and one line at a time.