Monthly Archives: March 2015

SQL Server Table Size

Tip for future reference.  Use the below from SSMS to get stats on the size of a table. exec sp_spaceused ‘<tablename>’ Advertisements

Posted in SQL Server | Leave a comment

Remove Empty Nodes XSL

Added here for my own personal cut ‘n’ paste reuse. Drop all empty nodes from an outbound message. Compile the attached into a BizTalk map using the custom XSLT override BizTalk mapper functionality and then call with the streaming transform … Continue reading

Posted in BizTalk Server | Leave a comment

BizTalk Streaming Transform Pipeline Component

Simple component to run a BizTalk map in streaming fashion. The mapName pipeline property is the fully qualified map name. e.g. Microsoft.Practices.ESB.ExceptionHandling.Maps.FaultMessage_to_ExceptionSql, Microsoft.Practices.ESB.ExceptionHandling.Maps, Version=2.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 StreamingTransform.cs Helper.cs

Posted in BizTalk Server | 1 Comment

XML Refinery BizTalk Pipeline Component

Simple BizTalk pipeline component to cleanse outbound messages.  Basically end game is for testers and administrators to be able to define fields to be removed from outbound messages without having to go back to the development team to have the … Continue reading

Posted in BizTalk Server | Leave a comment

BizTalk 2013 JDE Enterprise One 9.1

JDE connectivity is always “fun”.  When getting BizTalk Server 2013 happily talking with JDE 9.1 keep an eye out for the below. We had issues getting the 64bit edition of JDK 8 update 32 to work with the adapter.  Consistently received … Continue reading

Posted in BizTalk Server | Leave a comment