Nick,
I was able to see the below message from SQL before transforming it to another message.
<?xml version=”1.0″ encoding=”utf-16″?>
<Res xmlns=”http://SQL_Gen”>
<Student SNO=”2″ Name=”Kumar” Physics=”68″ Chemistry=”95″ />
</Res>
After transforming it to point SNO to SNo and Name to Name in output xml, I am getting the below xml.
<?xml version=”1.0″ encoding=”utf-8″ ?>
<ns0:StudentOut xmlns:ns0=”http://SQL_Proc_Sample.Schema2“ />
Please let me know if you can see any issue in the xml generated from SQL