- This topic has 3 replies, 1 voice, and was last updated 9 years, 1 month ago by
.
-
Posts
-
-
I need to update a table in Sql server where the file name in the column would be something like “abc.xml”. But how to get this in the orchestration as the (FILE.ReceivedFileName) property procures the entire name viz. “C:\Abc\Def\abc.xml”? So, it requires that the entire name be used in the database, which is not to be in my case as the entry is like “abc.xml”.
-
Hi Abhishek.
Didn’t you post something similar in an earlier thread on this forum? Anyway, you can do something like the following code in an Expression shape:
MyVariable = mIncomingMessage(FILE.ReceivedFileName);
MyVariable = MyVariable.Substring(MyVariable.LastIndexOf(@”\”) + 1);
MyVariable is an orchestration variable of type System.String, and mIncomingMessage is the message type of the schema associated with the incoming message that triggers your orchestration.
Hope this helps,
Daniel.
-
Hi xman71,
I had, indeed, posted a similar message in an earlier thread. But, you see that my inputs were not accurate owing to which, there was a communication barrier in that i wasn’t getting proper answers.
Anyway, thank you very much for the suggestion/s. They really help.
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.