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

Viewing 1 reply thread
  • Author
    Posts
    • August 19, 2010 at 1:54 AM #25676
      community-content

        Hi friends,

        I have a scenario in which a file is generated at a folder location and based on the file-name, I have to update an entry in a database table. Is this possible? If yes, how is it to be achieved?

        Awaiting a reply at the earliest.

      • August 19, 2010 at 12:04 PM #25689
        community-content

          Hi Abhishek,

           

             The property FILE.ReceivedFileName is one of the promoted properties by BizTalk that you can query on your incoming message. You can then parse that value and extract the filename part in an Expression shape.

           

             Daniel.

           

          • August 27, 2010 at 1:22 AM #25764
            community-content

              Can’t the filename part be done in the message assignment shape? That is because i tried and it didn’t work and also, the SQL entry needs to be the whole path viz. “D:\A\bab\pdf.pdf”.

              How is this to be sorted out?

        • Author
          Posts
        Viewing 1 reply thread
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.