Re: Updating Database table based on the filename of the file generated at the send port

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Updating Database table based on the filename of the file generated at the send port › Re: Updating Database table based on the filename of the file generated at the send port

August 27, 2010 at 8:15 AM #25768
community-content

    Hi Abhishek,

     

       If you are assigning to the SQL request message, you can do that in a message assignment shape by running XPath queries against your message to assign the whole path from the promoted property FILE.ReceivedFileName. See the following BizTalkGurus blog for more information on how to use XPath in an orchestration:

    http://www.biztalkgurus.com/blogs/biztalk/archive/2004/10/25/Using-XPath-Inside-BizTalk-Orchestrations.aspx

     

      Daniel.