With BizTalk, we often archive files in a disk directory, where each Vendor has its own archive. Simple Example I found the simple example below, then expanded upon: <pre> Get-ChildItem E:\Archive | Measure-Object -Property Length -sum </pre> Source from http://woshub.com/powershell-get-folder-sizes/ Fancy Example This starts with the Archive directory then basically runs the command above for […]
Scenario Let’s say you have a directory with a 100 files, and you want to slowly drop those file into BizTalk (via a file adapter Receive Location). Rather than copying all the files at once, you would like to wait 2, 5, or 10 seconds between each file drop? Maybe you want to make the […]
In the system I’m working with the dates in DB2 are defined as type “DECIMAL”, the they are stored as offsets from 19000000. Note, it’s not the number of days since 1900-00-00, but literally the the current date (YYYYMMDD less 19000000). T-SQL converting numeric DB2 date to something more readable Thus, when using a T-SQL […]
ToNoIt – “To Know it is Everything” What if you knew the big swings and trends in BitCoin and other cryptos. Marius Landman has able to correctly predict over 90% of the major swings in the market. He grew up as a poor orphan in South Africa, and went on to be on an elite […]
Here’s an example where I wanted to create a small XML file with a unique list of TerminalIDs from my application. On the left, which I had to blur out, the Looping functoid is connected to a parent record that repeats, and the other lines are connect to the source of the TerminalID. The scripting […]
How to run a SQL command against a Microsoft SQL Server Database (MSSQL) from a PowerShell script. <pre> cls $datasource = "server=server\instance;database=mydb;trusted_connection=true" #if not using Integrated Security, #you might want to pass user/pass in variables or prompt for them #$connectionString = 'User Id=' + $username + ';Password=' + $password + ';' + $datasource $connectionString = […]
As of BizTalk 2020 and Visual Studio 2019, when you click on the map grid, you get the map properties window, on which you can select various “XSLT Transformation Engines”. BizTalk 2020 supports XSLT 3.0 via the Saxon transformation tool, which is created by Saxonica. Microsoft apparently chose the open source “Home Edition” (HE), and […]
I found myself doing three boring tasks over and over again after each deploy: Restarting a BizTalk Host Instance Running a SQL command Disable/re-Enable the Receive Location for SQL Polling. I could potentially add a build/deploy step at the top, to combine that as well… maybe one of these days soon… To force the SQL […]
I’ve done this many times before, but today, I had numerous issues. 1. I didn’t give the C# subroutine a strong name, and thus it wasn’t in the GAC. This result in “Load Failure” or “Could not load file or assembly…” 2. GacUtil getting code 1 or code 3. I think the code 1 was […]
EventLog error on a typed-polling BizTalk WCF-SQL Receive Location There was a failure executing the receive pipeline: “Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35” Source: “XML disassembler” Receive Port: “ReceivePort.dlsqldev1.tmwdev.Integration_Dev.GetSettlementTWMtoIseries” URI: “mssql://sqlserver//dbname?InboundId=XYZData” Reason: Finding the document specification by message type “http://schemas.microsoft.com/Sql/2008/05/TypedPolling/XYZData#TypedPolling” failed. Verify the schema deployed properly. Anybody around BizTalk a while knows what this error means […]