Get the name of received file in Biztalk

Thursday, June 30, 2011


Get the name of received file in Biz talk  and Map it to any Element 

         Use the following  Property in Custom pipeline to read the File Name Property

PropertyValue = pInMsg.Context.Read("ReceivedFileName","http://schemas.microsoft.com/BizTalk/2003/file-
properties")

There are more than a couple to achieve this thee above description is  for  accesing filename in pipeline
what if you want to access else where in biztalk 

lets see:

How to access the  received file name at port level : Use  %SourceFileName% macro at port level to access

How to access at orchestration : Use " File.ReceivedFileName "  .Net Property


I’m always forgetting the list of macros that I use, which leads me to always be looking for them, so here’s a list of send macros that you can use:
Macro name
Substitute value
%datetime%
Coordinated Universal Time (UTC) date time in the format YYYY-MM-DDThhmmss (for example, 1997-07-12T103508).
%datetime_bts2000%
UTC date time in the format YYYYMMDDhhmmsss, where sss means seconds and milliseconds (for example, 199707121035234 means 1997/07/12, 10:35:23 and 400 milliseconds).
%datetime.tz%
Local date time plus time zone from GMT in the format YYYY-MM-DDThhmmssTZD, (for example, 1997-07-12T103508+800).
%DestinationParty%
Name of the destination party. The value comes from the message context property BTS.DestinationParty.
%DestinationPartyQualifier%
Qualifier of the destination party. The value comes from the message context property BTS.DestinationPartyQualifier.
%MessageID%
Globally unique identifier (GUID) of the message in BizTalk Server. The value comes directly from the message context property BTS.MessageID.
%SourceFileName%
Name of the file from which the File adapter read the message. The file name includes the extension and excludes the file path, for example, Sample.xml. When substituting this property, the File adapter extracts the file name from the absolute file path stored in the FILE.ReceivedFileName context property. If the context property does not have a value—for example, if a message was received on an adapter other than the File adapter—the macro will not be substituted and will remain in the file name as is (for example, C:\Drop\%SourceFileName%).
Note: Correct implementation of this macro requires that the output message is the same message as the received message.
%SourceParty%
Name of the source party from which the File adapter received the message.
Note: Correct implementation of this macro requires that the output message is the same message as the received message.
%SourcePartyQualifier%
Qualifier of the source party from which the File adapter received the message.
Note: Correct implementation of this macro requires that the output message is the same message as the received message.
%time%
UTC time in the format hhmmss.
%time.tz%
Local time plus time zone from GMT in the format hhmmssTZD (for example, 124525+530).

No comments:

Post a Comment

Post Your Comment...