BizTalk XSLT & XPath Examples – Substring and Nested XPath with Where Clause

Two handy references for BizTalk XSLT: Substring in XSLT Value-Of XPATH The first example is fairly easy, I just needed to get the date/time without the timezone modifier, in other words to convert this: 2016-01-29T00:00:00-08:00 to this: 2016-01-29T00:00:00. The reason was that our web service was only coded to handle the date without the timezone. […]

BizTalk Map XSLT Error: The ‘=’ character cannot be included in a name

Sample Code Error MyMap.btm: error btm1023: Exception Caught: The ‘=’ character, hexadecimal value 0x3D, cannot be included in a name. Line 4, position 23. Solution This was a simple typo. I typed in “value-of-select=” instead of “value-of select=” (I erroneously included an extra dash between the “of” and the “select”). The parser saw the entire […]

Input format for testing a multi-message map

How do you test a multi-part map, i.e. a map with multiple input messages? To test a normal map, you just take an sample XML file, click the map (in Visual Studio Solution Explorer), set the property of the filename into the value of the property “TestMap Input”, then right-click on the map and select […]

How to Count and Purge your dta_DebugTrace in BizTalkDTADb

<br> USE BizTalkDTADb<br> –select top 10 * from dbo.dta_DebugTrace<br> select COUNT(*) from dbo.dta_DebugTrace as TotalRowCount <br> SELECT YEAR(dtBeginTimeStamp) AS Yr,<br> Month(dtBeginTimeStamp) AS Mo,<br> COUNT(*) AS [RowCount]<br> FROM dbo.dta_DebugTrace nolock<br> GROUP BY<br> YEAR(dtBeginTimeStamp),<br> DatePart(mm,dtBeginTimeStamp)<br> Order BY<br> YEAR(dtBeginTimeStamp),<br> Month(dtBeginTimeStamp)<br> The results show you by year/month how many rows. In most cases, you will find you need to […]

BizTalk Rosetta Schema Errors SerializableAttribute does not exit

I brought a Rosetta .xsd schema into a new BizTalk Project, gave it a compile and got 1524 occurences of the following error: The Build Errors —— Rebuild All started: Project: BTS2C7Outbound, Configuration: Debug Any CPU —— e:\MyDir\BTS2C7Outbound\Schemas\2C7\Domain\Logistics\CodeList\RN_ResponseCode_01_00.xsd.cs(13,17): error CS0234: The type or namespace name 'NonSerializedAttribute' does not exist in the namespace 'BTS2C7Outbound.Schemas._2C7.System' (are you […]