Using the ‘Microsoft OpenXml SDK’
https://docs.microsoft.com/en-us/office/open-xml/spreadsheets
Older method using ODBC etc
http://biztalk.stottcreations.com/2007/12/biztalk_excel_xls_pipeline_component/
Tag: Microsoft Biztalk
Limit number of simultaneous connections to a WCF host
General method (works also for HTTP)
BizTalk enables users to configure WCF host to limit the maximum connections to a particular address.
The connectionManagement element in the btsntsvc.config file is designed to specify the number of connections to a given address. By default BizTalk allows for 2 connections for any given WCF host.
How to limit number of connections
https://stackoverflow.com/questions/3591283/biztalk-how-to-limit-number-of-connections-to-a-wcf-service
Throttling
https://docs.microsoft.com/en-us/biztalk/technical-guides/optimizing-biztalk-server-wcf-adapter-performance
Add the ServiceThrottlingBehavior service behavior to a WCF-Custom or WCF-CustomIsolated Receive Location and use the following settings:
Compilation of Biztalk graphical map results in OutOfMemory
After upgrading our UBL schemas from 2.0 to 2.1, our maps utilizing that schema would not compile any more. All of them – except one – would build for a long-long time, and would finally result in an OutOfMemoryException. The map that was not affected, was a pure XSLT map.
The UBL schemas have now gotten so big, that Visual Studio can generate an OutOfMemory while building a Biztalk graphical map (pure XSLT maps are not affected). It also takes quite some time before the OutOfMemory occurs – in the mean while, you can see the VS process continually allocating memory.
Open the .BTM file in Notepad, and change the GenerateDefaultFixedNodes attribute from “Yes” to “No“.
Save and build again
Cannot add resource to Biztalk – No .CLB data in the memory or stream
We are running a Biztalk 2016 env., and here I have experienced issues when adding a BiztalkAssembly to Biztalk using the rightclick + “Add Resource” on an Application in the Biztalk Admin Console. It gives this error:
It currently only occurs with a single DLL, containing a schema, where there are LOTS of maps that Biztalk want to remove (and redeploy afterwards) before adding this schema.
It gives exactly the same error, if I try to add the resource using BTSTASK
BTSTASK AddResource -ApplicationName:"Object.Invoice" -Type:"System.BizTalk:BizTalkAssembly" -OverWrite -Options:GacOnAdd,GacOnImport,GacOnInstall -Server:biztalkdev01\dbinst01 -Database:BizTalkMgmtDb -Source:c:\dll\BizTalk.Object.Invoice.Schemas.CDM_Invoice.dll
It also makes no difference, if I run the BTSTASK in a standard CMD or as “Administrator”
The only thing that works, is if I add the resource from another directory, than the one I added it from the previous time. In the example above, it works, if I change the source to “c:\dll2\……” (and copy the DLL there)
[srs_total_visitors]