Read Attribute values using XPath or Other alternative

Hi,

I need to read from xml during transformation . based on some parameter i need to identify sending location. Following is my xml and XML is generatin from database (SQL Server 2005)

– <ns0:BOAArlineItem xmlns:ns0=”http://BOAArlineItem“>
  <ns0:dbo.BELB_History recordbatchnumber=”recordbatchnumber_0″ RecordLockboxnumber=”RecordLockboxnumber_1″ contechdepositdate=”contechdepositdate_2″ EXPORTRECORDLINE=”EXPORTRECORDLINE_3″ />
  <ns0:dbo.BELB_History recordbatchnumber=”recordbatchnumber_0″ RecordLockboxnumber=”RecordLockboxnumber_1″ contechdepositdate=”contechdepositdate_2″ EXPORTRECORDLINE=”EXPORTRECORDLINE_3″ />
  <ns0:dbo.BELB_History recordbatchnumber=”recordbatchnumber_0″ RecordLockboxnumber=”RecordLockboxnumber_1″ contechdepositdate=”contechdepositdate_2″ EXPORTRECORDLINE=”EXPORTRECORDLINE_3″ />
  </ns0:BOAArlineItem>

Attributes recordbatchnumber, RecordLockboxnumber and contechdepositdate value would be same in all the record in file

Now I need to read those attribute value and generate sending file name.

I have used xPath to read attribute values from xml.  following is the code for reading attribute using xpath

//Get the path of the the first HeaderInfo Element
HeaderInfoPath = System.String.Format(“//dbo.BankExternalLockBox_History[{0}]”,1);
XmlDoc = xpath(BOAArlineItemMSG,HeaderInfoPath);

//Construct Message
XmlDocMSG = XmlDoc;

LockBoxNo = xpath(XmlDocMSG,”string(/dbo.BankExternalLockBox_History/RecordLockboxnumber)”);
BatchNo = xpath(XmlDocMSG,”string(/dbo.BankExternalLockBox_History/recordbatchnumber)”);

SendFileName = LockBoxNo + BatchNo + System.DateTime.Now.Date.ToString() + “.txt”;

OUTBOAArlineMSG(FILE.ReceivedFileName) = SendFileName; 

Can anyone suggest how to use xPath within orchestration or suggest other alternative?

Thanks for early response.

Regards,

– Dhaval M.