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

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

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

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