Sunday, November 29, 2009

BizTalk : Get Received File Name In Orchestration For FTP Adapter

I had a requirement to read received file name(FTP adapter) within orchestration. I found the solution and that is

InboundMessage(FTP.ReceivedFileName)

Add expression shape on Orchestration and add above code. Replace "InboundMessage" with actual inboundmessage name.

Wednesday, August 26, 2009

Reading Data From Excel - Use ExcelDataReader

In one of project, i supposed to read data from Excel. I found following component very useful to achieve this task, specially when you don't want to store excel file on hard drive.

http://exceldatareader.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=27275#ReleaseFiles


You can read data because this tool returns data in Dataset.


Aditya's Snap