This class makes it very easy, almost trivial, to convert SQL query results into XML, but a major disadvantage of OracleXMLQuery is that it is a proprietary solution.

Problem: I'd like to import that using bulk import in MS SQL server 2005. Unfortunately, I don't quite understand how I can specify a non-printable character as delimiter (is that even possible ?).

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.