Email a list of new files (Powershell)

My goal here was to send myself an email of all new files received from vendors. This is assuming the files are not picked up and processed by BizTalk automatically. If that were the case, you might be able to point the folders to your archive directories and still achieve the same results. In my […]

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 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, […]

BizTalk Error: The document specification failed to load

Error: The document specification <ddlname.schemaName+SchemaRootNode> from assembly <etc…> failed to load.  Verify the schema for this document specification is deployed and is in the Global Assembly Cache. Solution 1: In our case, this happened when we ran a C# client tester program that called an orchestration published as a WCF service.  The Application Pool was […]

“AutoAudit” – CodePlex Free Utility to Build SQLServer Triggers – Documentation and Example

CodePlex is long gone, but the script can now be found here: https://github.com/koenmd/AutoAudit/blob/master/README.md A few years ago I discovered a great utility called “Auto Audit” on CodePlex by Paul Nielson (author of “Sql Bible”) and John Sigouin. The best thing is that it creates triggers that audit insert, update, and deletes on any desired table. […]

What happened to the GAC in .NET 4.0?

As you are well aware, all BizTalk programs must reside in the GAC. Many of use the “shell extension” to drag and drop programs to the GAC. But BEWARE, this tool is gone in .NET 4.0. See here for the Microsoft Official Statement: https://msdn.microsoft.com/en-us/library/vstudio/34149zk3%28v=vs.100%29.aspx Former link was moved by MSDN: http://msdn.microsoft.com/en-us/library/34149zk3.aspx “Beginning with the .NET […]