sqlxml

Invalid character value for cast specification

I am inserting data into SQL 2005 using SQLXMLBulkLoad.SQLXMLBulkload.3.0 My data table has following column: objDataTable.Columns.Add("TaskDateTime", System.Type.GetType("System.DateTime")) My bulk insert schema has following definition: <xsd:element name="DepartureTime" type="xsd:date" /> (Using xmlns:xsd="http://www.w3.org/2001/XMLS...

xsd schema file must be annotated in SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class?

Here is an example to use SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class - [STAThread] static void Main(string[] args) { try { SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class objBL = new SQLXMLBULKLOADLib.SQLXMLBulkLoad4Class(); objBL.ConnectionString = "Provider=sqloledb;server=server;database=databas...

Adding a unique row count to a SQL 2008 "for xml path" statement?

Ok, not sure if this is possible to do.. I have a query that returns just simple records from the database, but formatted out as XML as follows: select name, address, dateCreated, flag from table where name = 'test' for xml path('row'), root('rows') ok, no problems, and I get the XML as desired: <rows> <row> <name>jddjdjd</nam...