I'm using BizTalk 2013r2.

I have a simple message-only process (no orchestrations) that selects data from Oracle and sends to an external party via sFTP.

I've created a TPE profile which is successfully writing useful data to BAM. My problem is, I also need to log the sent filename. I have mapped the following property to the send port: SFTP.bts_sftp_properties.TargetFileName as shown below:

<Dimension Name="SentFilename" DataType="NVARCHAR">
    <DataLevel Name="TargetFileName" SourceTypeSelected="Messaging Context Property" SchemaName="SFTP.bts_sftp_properties,Microsoft.BizTalk.GlobalPropertySchemas, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" SomXPath="/*[local-name()='&lt;Schema&gt;' and namespace-uri()='http://schemas.microsoft.com/BizTalk/2012/Adapter/sftp-properties']/*[local-name()='TargetFileName' and namespace-uri()='http://schemas.microsoft.com/BizTalk/2012/Adapter/sftp-properties']" XPath="/*[local-name()='TargetFileName' and namespace-uri()='http://schemas.microsoft.com/BizTalk/2012/Adapter/sftp-properties']">
      <Port Name="SilverpopSendCustSurvey_sFTP" Direction="Send" />
    </DataLevel>
  </Dimension>

I have then applied the tracking profile. As I say, all is being logged except TargetFileName. I have checked all the relevant tables of the BAM Primary Import database. I'm thinking maybe there's a fault with the adapter?

Hi Rob,

TargetFileName represents the full name of the file from where the adapter locates the message. It's recommended to use web based BizTalk monitoring and support tool for Microsoft BizTalk Server(BizTalk360), and check whether it can give some hints why this happens.

Regards,

Angie

I'm sure even the CEO of BizTalk360 would agree this answer has no relevance to the question.

Hi Rob,

We had the same issue with SFTP pass through receive pipeline not capturing the file name. One of my colleague confirmed that it has been fixed with latest cumulative update (CU1) for BizTalk 2013 R2.

Here is the link to CU1. Please install it and test the file name

https://support.microsoft.com/en-us/kb/3055198

Cheers

That's great - thanks