I needed to implement RawString functionality to be able to read a non-XML file into an orchestration. Scott Colestock had a great article on this on his TraceOfThought blog, but when I needed it the other day, it had been hacked (hopefully only temporary). 1. Deploy the C# code towards the bottom of this log; […]
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 […]
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 […]
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 […]