Inbound File Name Hipaa Accelerator BizTalk 2006

I have seen many blogs to get the Source File Name in Hipaa Adapter as the Hipaa Accelerator removes the file name properties when it converts EDI to XML format and the SourceFileName Macro also doesnt work.To solve this issue follow these simple steps
1.Original file name is stored in Hipaa Accelerator database and the Table name is audin and the column name is origfilename.
2.In Audin Table we have icr as control Number,sid as sender Id ,rid as receiver ID and Date and time (HHMM) format is stored in these tables
3.For each EDI file we can have only control number and also Hipaa accelerator does not allow duplicate files to process as per its design
4.Create Store Proc on Hipaa Accelarto Db as
Select OrigFileName from audin where icr=@controlnumber and sid=@senderid and rid=@receiverid and date=@datefield and time=@timefield
5.We all know these values comes from the edi file either use a store procedure functoid in the map to get the filename or you can use an SQL port to execute the store procedure
6.Once we have the file name in the map or in orchestration we can write the inbound filename
Please email me or send me request if you have questions or comments on this article
Thanks