• 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