none
How to get the incoming filename and store it to sql table using biztalk server 2013 RRS feed

  • Question

  • HI,

    1)I need to get the incoming EDI filename which is received and save the filename in to the database.

    2)How can i get the EDI Duplicate filename if i set the do not allow duplicate under validation tab in X12 agreement settings in biztalk admin console. In this case since the duplicate file will not come in to orchestration. In this case how can i acheive this.

    Thanks,

    Vijayan


    vijayan

    Tuesday, September 2, 2014 9:20 AM

Answers

  • For both cases, the filename can be found on the FILE.ReceivedFileName Context Property.  You can access this Property in a Pipeline Component or Orchestration and take any action you want, such as apply to a database.

    The value is accessed by: MyReceivedMessage(FILE.ReceivedFileName)

    In the case of a duplicate EDI Interchange, you would use the Failed Message Routing feature to capture the error message with either an Orchestration or Send Port.

    • Proposed as answer by Leonid Ganeline Wednesday, September 3, 2014 5:43 PM
    • Marked as answer by Pengzhen Song Tuesday, September 9, 2014 11:04 AM
    Tuesday, September 2, 2014 12:21 PM