How to Filter by Filename by Mask in BizTalk

Business Requirement: Only send an email to the credit department if the filename contains the word “EXPORT” and and ends with .txt. We cannot put *EXPORT*.txt in the Receive Location, because there are other files coming in with different patterns. Question: How would you do that in BizTalk? BizTalk has filters on the send ports. […]

BizTalk AS2 Error: The underlying connection was closed: The connection was closed unexpectedly.

The underlying connection was closed: The connection was closed unexpectedly. I’m sure there are numerous reasons for this error, but here’s one I encountered today. First the background. We have BizTalk server connecting to an internal Open/AS2 server running on Linux. That Linux server was re-installed on a Virtual Machine; and I had agreed with […]

Using BizTalk Poweshell Extensions to List/Start/Stop SendPorts, ReceivePorts…

Here are some samples you can use to list, start/stop, enable/disable, enlist/unenlist and so on your Send Ports, Receive Ports, and Recieve Locations. Note the path hierarchy. You must specify you application name. I’m using “BizTalk EDI Application” since anyone with EDI installed will have the same results. Sample Script cls Add-PSSnapIn -Name BiztalkFactory.PowerShell.Extensions #NOTE: […]

List/Start/Stop Host Instances with Biztalk Powershell Extensions

When dealing with Host Instances, you must specify the fully-qualified name, or use a couple of tricks I show in this blog. I’ve been setting up some pre-canned scripts that I can just open when needed, and that have already been tested. Today I was looking at listing, starting, and stopping BizTalk Host Instances. Powershell […]

Update Adapters with Host Names in BizTalk Powershell Extensions

After you add Host and Host-Instances to BizTalk, they are not useful and cannot be associated with Send/Receive ports until you relate the Host to the Adapter. This can be done in BizTalk Admin Console, but below is a program that allows you to do it with the BizTalk Powershell Extensions. See related script to […]

How to set Isolated vs In-Process when creating BizTalk Host with Powershell

The following shows how to set the $HostType for the BizTalk Powershell Extensions. if ($HostType -eq "Isolated")    {      $HostTypeCode = 2  #Isolated    }    else    {      $HostTypeCode = 1  #In-Process    } $temp = New-Item -path $hostName -HostType:$HostTypeCode -NtGroupName:$myNTHostGroupName -AuthTrusted:$AuthTrusted See full function in this blog about Adding BizTalk Hosts and Hostinstances […]

BizTalk PowerShell Extensions not Found (not Installed)

Error: No snaps-ins have been registered for Windows PowerShell You run the following: <pre>cls Add-PSSnapIn -Name BiztalkFactory.PowerShell.Extensions  #NOTE: Must be in 32-bit version of Powershellto use this SnapIn </pre>   And you get this error: <pre>Add-PSSnapIn : No snap-ins have been registered for Windows PowerShell version 3. </pre> First – make sure you are using a […]

BizTalk Pipeline Component Won’t Go into Debug Mode in Visual Studio Debugger

The following may help with a variety of custom pipeline component issues, including why your “Debug” is not catching when you expect it to. There were times today, where I would do “Debug Attach” to the BizTalk Host Instance, and the component would never go into debug mode. 1. Check that date/time of the .DLL […]

BizTalk 2016 – Could not load file or assembly ‘WinSCPnet, Version=1.2.10.6257

Error: The adapter failed to transmit message going to send port “sp_Test_SFTP” with URL “sftp://sftp.mycompany.com:22/%MessageID%.xml”. It will be retransmitted after the retry interval specified for this Send Port. Details:”System.IO.FileLoadException: Could not load file or assembly ‘WinSCPnet, Version=1.2.10.6257, Culture=neutral, PublicKeyToken=2271ec4a3c56d0bf’ or one of its dependencies. General Exception (Exception from HRESULT: 0x80131500) File name: ‘WinSCPnet, Version=1.2.10.6257, Culture=neutral, […]