I recently showed a VBScript to Archive/Move xml files to a subfolder. This is often needed when you have been archive or storing 1000s of XML files, and the the directory/folder is very slow to open due to the large number of files. Now, we will do it in Powershell. Create the subfolders ahead of […]
Business Problem/Scenario I had a .bat file with 50 lines or more, and many of them had disk paths. We were migrating this to production, so I did “replace all” commands to change all the paths to production SAN/Server names. But then, I knew some of the paths existed, and some didn’t. So I wanted […]
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. […]
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 […]
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 […]
<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 […]
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 […]
I had a case today where I was mapping two fields N01 and N02 to two side by side fields in the output schema. N01 was working, and N02 wasn’t. Both were under an condition that a certain variable MESSAGE_TYPE was equal to a certain value. Yet one worked, the other didn’t? How did I […]
In the past, I admit, I was a GAC’cer. Yes, that means that I would run GACUTIL to deploy minor code changes to BizTalk Ochestrations. Where I currently work, that is not the best practice for several reasons. One reason is that if you create an MSI after doing the GAC, the MSI will not […]
This blog contains a sample VBScript to start a BizTalk Orchestration The SDK (Software Development Kit) of BizTalk includes a sample to stop orchestrations. “c:\Program Files (x86)\Microsoft BizTalk Server 2010\SDK\Samples\Admin\WMI\Stop Orchestration\VBScript\StopOrch.vbs” I guess, since it is just a sample, they chose not to provide the opposite to “Start” orchestrations. I was having to deploy just […]