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...
Biztalk Schema versioning
Thursday, June 30, 2011
By Vincent ScheelDifferent VERSIONS OF A SCHEMA SIDE BY SIDE AND USING THEM IN ORCHESTRATIONSSchema versioning in BizTalk is always a difficult thing to do. When small changes are done on a schema (for a new solution), but this schema is already in use by a solution which is currently in production, you have to be very careful.BizTalk defines...
Biztalk 2010 GAC Issue
Thursday, June 30, 2011
Q:VS 2010 uses .Net 4.0 and Net 4.0 gac's the dlls into the new GAC location (C:\Windows\Microsoft.NET\assembly\GAC_MSIL\ProjectName\v4.0_\*.dll)
wheras Biztalk uses GAC loc as C:\Windows\assembly folder for all the dlls and all the default and esb Biztalk dlls are located here. When i create a Biztalk project it deploys fine in Biztalk DB wheras the dlls are Gac'd in the new GAC loc.
At runtime Biztalk is looking for the dlls...
Biztalk 2010 GAC Issue
Thursday, June 30, 2011
Q:VS 2010 uses .Net 4.0 and Net 4.0 gac's the dlls into the new GAC location (C:\Windows\Microsoft.NET\assembly\GAC_MSIL\ProjectName\v4.0_\*.dll)
wheras Biztalk uses GAC loc as C:\Windows\assembly folder for all the dlls and all the default and esb Biztalk dlls are located here. When i create a Biztalk project it deploys fine in Biztalk DB wheras the dlls are Gac'd in the new GAC loc.
At runtime Biztalk is looking for the dlls...
Using FOR XML queries with the WCF-SQL Adapter
Thursday, June 30, 2011
By Dan RosanovaThe WCF-SQL adapter is the official replacement for the old SQL Adapter in BizTalk and is available across three versions of the product (2006 R2, 2009 and 2010). This adapter greatly increases the capabilities of interacting with SQL Server from BizTalk. It also advertises backwards compatibility with the older adapter....
Using Sql Adapter in Biztalk 2010
Thursday, June 30, 2011
Q:
Anyone every actually pull off a successful FORXML polling query using the WCF-SQL Adapter? The documentation on MSDN for this does not seem to show a clear way to do it. Every example is a trivial 'this is so easy with a simple single table not using the classic SQL adpter' and I'm at my wits end with it. Something that takes 30 seconds with the old adapter is taking all day and not working... and involving...
Mapping Repeating Sequence Groups in BizTalk
Wednesday, June 29, 2011
Repeating sequence groups can often be seen in real life XML documents. It happens when certain sequence of elements repeats in the instance document. Here's fairly abstract example of schema definition that contains sequence group:<xs:schema xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="NS-Schema1" targetNamespace="NS-Schema1" > <xs:element name="RepeatingSequenceGroups"> <xs:complexType> <xs:sequence maxOccurs="1" minOccurs="0"> <xs:sequence maxOccurs="unbounded"> <xs:element name="A" type="xs:string" /> <xs:element name="B" type="xs:string" /> <xs:element name="C" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:sequence> </xs:complexType> </xs:element></xs:schema>And...
Subscribe to:
Posts (Atom)