Yet another late reply:
We mostly use xp_cmdshell + BCP in combination with format files. I'd be very interested in seeing a CLR assembly that would be able to read a format file and export the data accordingly.
(of course, if you can actually execute BCP from CLR, this problem is automatically solved).
Thank you for considering this!
Kind regards
- Pesche