All posts by : BizTalk Community Blogs via Syndication

1 of 457 | System Integration with Nintex Workflow for SharePoint 2007 (Part II) - In my previous post I briefly described what the workflow tool from Nintex looks like and how to use it within the SharePoint environment.  Now, let’s see how to actually perform our first system integration scenario through the use of web...(read more)...

2 of 457 | BizTalk Server 2009 - automated build & deployment using TFS 2008 – parameterization - This post is all about how you can parameterize your builds to work in different scenarios. Before you read this, please take a moment to read Mikaels introductory blog post and take a look at my webcast on Channel9 [~18m], if you haven't already...(read more)...

3 of 457 | BizTalk WCF Custom Adapter – Developing WCF Custom Behaviours - As you sink your teeth into the depths of BizTalk 2006 R2/2009 and realise the potential of integrating with the WCF Custom Adapter, a new world opens up. Then… Then at one point down the track you’ll want to tweak or customise what is being sent/received...(read more)...

4 of 457 | What's new with web services in Silverlight 3 Beta - Cross-posted from the Silverlight Web Services Team Blog . Silverlight 3 beta comes with a set of exciting web services features that address key customer requests. Binary message encoding In Silverlight 2 the only supported binding was BasicHttpBinding, which encodes outgoing messages as text and sends them over an HTTP transport. This binding is great for interoperability with SOAP 1.1 services and is also easily debuggable since messages can be viewed in plain text on the wire using HTTP debugging...(read more)...

5 of 457 | Getting the product key of a BizTalk installation - I received an unusual phone call from a co-worker today: he wanted to find out the product key of BizTalk Server 2006 installed on a server (I didn’t go as far as asking why – lost disk probably). After a few minutes this is where I got to: open regedit...(read more)...

6 of 457 | SQL Bulk Load adapter - While creating the EDI Warehouse, for EDI files that were large (10mb transactions), I was seeing 1 of two things with the SQL Adapter: Out of memory exceptions Taking hours to load data with high sql server usage In opening a ticket with Microsoft to...(read more)...

7 of 457 | Gotcha when Exporting Adapter Config in Binding Files - Originally posted by Nick Heppleston at: http://www.modhul.com/2009/02/17/gotcha-when-exporting-adapter-config-in-binding-files/ This one caught me out today - hope it might help others in the future… If you export Bindings to get the lovely syntax...(read more)...

8 of 457 | Speaking in San Diego tonight (Feb 17 2009) – Microsoft’s SOA offerings - I’ll be speaking at the ASP.NET SIG of the San Diego .NET User Group tonight. Abstract is below. Meeting starts at 6:00 at the Microsoft La Jolla office. This is basically the same presentation Allan Naim and I did recently at the SOA BP conference in...(read more)...

9 of 457 | BizTalk 2006 R2 EDI Gotcha: Sending 997s in Response to Received 997s - I was seeing a weird behavior where I thought BizTalk 2006 R2 was sending a 997 in response to a received 997. The real reason was because I had a send port filter that looked like the following: You'll notice that I'm subscribing to a receive...(read more)...

10 of 457 | Higher Standards for Web Standards - Since the emergence of web services in the 90s, we’ve seen an explosion of standards and standards bodies. Sometimes, they emerge based on new innovations, other times they’re created to unblock a stalemate on a similar standard or organization. Occasionally...(read more)...

11 of 457 | Presenting at Code Camp Oz 2009 - For all those that have attended the Code Camp Oz events in the past, this years event is shaping up very nicely, lots of great topics and speakers. I will be presenting the following 2 topics: Saturday - 15:15 Full Session - A Dive into Dublin: WF and...(read more)...

12 of 457 | Presenting at Code Camp Oz 2009 - For all those that have attended the Code Camp Oz events in the past, this years event is shaping up very nicely, lots of great topics and speakers. I will be presenting the following 2 topics: Saturday - 15:15 Full Session - A Dive into Dublin: WF and...(read more)...

13 of 457 | BizTalk Server 2006 R2 Exam (70-241) -   I’ve just taken exam Exam 70-241: TS: Developing Business Process and Integration Solutions by Using Microsoft BizTalk Server 2006 R2 and passed! This exam has been brought to my attention again two weeks ago by Nabeel from Microsoft Services in...(read more)...

14 of 457 | New video on using Team Foundation Server for BizTalk Server 2009 development with -   The Channel 9 Screencasts has a new video on using Team Foundation Server for BizTalk Server 2009 with Johan Hedberg from the BizTalk User Group in sweden. Johan goes over the basics of creating a new build type and building BizTalk 2009 projects...(read more)...

15 of 457 | Using WS-Discovery in WCF 4.0 - Runtime endpoint discovery is one of the most challenging capabilities to implement in service oriented systems. Dynamically resolving service’s endpoints based on predefined criteria is a necessary functionality to interact with services which endpoint...(read more)...

16 of 457 | BizTalk 2009 - Build & Deploy automation with Team Foundation Server 2008 – Part 1 - BizTalk Server 2009 comes with support for MSBuild. The question is, how can we use it, and how does it help us? The obvious advantage is of course, that this enables Visual Studio BizTalk projects to be deployed to the production environment without...(read more)...

17 of 457 | Hosting a WF 4.0 workflow service in “Dublin” - I did a post a couple of months back where I showed you how to take a WCF service and host it on the Azure service platform . I thought that was pretty cool, but wanted to take it to the next level. So, why not call that from a .NET 4.0 workflow, and...(read more)...

18 of 457 | Hosting a WF 4.0 workflow service in “Dublin” - I did a post a couple of months back where I showed you how to take a WCF service and host it on the Azure service platform . I thought that was pretty cool, but wanted to take it to the next level. So, why not call that from a .NET 4.0 workflow, and...(read more)...

19 of 457 | IDisposable, WCF, and Hole In The Middle - Steve Smith recently posted about the problem of the Close() (or Dispose()) method throwing an exception in WCF.  He proposed a solution that was an extension method to the ICommunicationObject interface and handled safely closing the connection...(read more)...

20 of 457 | Updategram with multiple tables with foreign keys - Updategram Overview Since SQL Server 2000, updategrams along with OPENXML have been available to insert, update, or delete data using XML documents. An updategram works against the XML views that are provided by the annotated XSD schema that contains...(read more)...

21 of 457 | xml output - my query has this format: SET @output= (SELECT … FOR XML PATH('APSHMSA'),root('TABLE'),ELEMENTS,type) select convert(varchar(max),@output) as xml I can see the input when I click on Preview I can see the input when I click on Preview However...(read more)...

22 of 457 | BizTalk Server vs “Dublin” - Ever since PDC ‘08 and the announcement of “Dublin” the world has gone mad with the buzz. But what exactly is “Dublin”, where does it fit in with BizTalk? Does it replace BizTalk? All these are valid and interesting questions, questions that have been...(read more)...

23 of 457 | BizTalk Posters Updated for BizTalk 2009 - The MS Technical Editors responsible for the BizTalk posters have recently updated some of the posters for BizTalk 2009.  Check them out at the following URLs: · BizTalk Server 2009 Scale-out Configurations Poster · BizTalk Server 2009 Database Infrastructure...(read more)...

24 of 457 | FOR XML PATH - In creating xml data from table data, I came across the need to create empty elements even in there are null values in the columns I am querying. I first used this logic to force the generation of the tag: SELECT EmployeeID as " @EmpID " , FirstName...(read more)...

25 of 457 | BizTalk Server 2004 Mainstream Support Ends July 14, 2009 - For all those still running BizTalk Server 2004, they should be aware that the Microsoft Mainstream support will end this year ( http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=2004&Filter=FilterNO ). One other point to...(read more)...

26 of 457 | VS2008 - Generate XML Instances - It’s funny how we take things for granted. As Biztalk developers, we get used to the idea of being able to right click on a schema and generate an instance . In non Biztalk projects however, this couldnt be done. Till now. I was playing around with...(read more)...

27 of 457 | BizTalk 2006 R2 X12 EDI Batching - I had a requirement to extract several thousand rows of X12 data from a back end database and package them up once a month into X12 EDI with a max of 5000 rows per Transaction Set and maximum 4 Transaction Sets per file. I found that there was no out...(read more)...

28 of 457 | BizTalk 2009 Beta Docs & BAM Guidance - Microsoft just published a very interesting an in-depth 86-page document about BAM, one of the most under-used features of BizTalk Server, “Business Activity Monitoring in Depth for Developers”. You can download if here , and find more overview info about...(read more)...

29 of 457 | Slides for my Capabilities of BizTalk Server 2009 talk for ACSUG - Just a quick note that the slides for my talk on BizTalk 2009 on the 22/01/09 for the Auckland Connected Systems User Group can be downloaded from the Attachments section of this page: http://www.acsug.co.nz/Meetings/New-Capabilities-of-BizTalk-2009—Thiago...(read more)...

30 of 457 | BizTalk Server 2009 session at TechDays 2009 - I will together with Johan Hedberg speak at TechDays 2009 in Västerås, and give a session about new features in the upcoming release of BizTalk Server 2009. We’ll also be present representing the Swedish BizTalk User Group. If you will be there, come...(read more)...

31 of 457 | Microsoft's StockTrade is now part of Apache's Stonehenge - Last week, Microsoft showed their commitment to promote best practices around Web Services interoperability by donating a version of the famous StockTrader application to the Apache Stonehenge project. For those of you not familiar with Stonehenge , it...(read more)...

32 of 457 | The Road to WF 4.0 (Part 1) - The topic of 4.0 migrations has come up several times over the past week – in e-mail conversations with a few authors and meetings with customers, on a couple articles (e.g., Kathleen Dollard ; Aaron Skonnard ), and a cross-blog conversation . As such, it seemed a good time to post a couple blog entries on the topic. There will be more specifics coming out on this topic in the near term, but I’ll touch on that at the end of this entry. As any of the links above will tell you, we announced at PDC...(read more)...

33 of 457 | Selecting Unknown Nodes in XPath - My currrent project can invoke several common web-services that return roughly the same data, but with slightly different sub elements. I have just had a requirement to count the number of these slightly differing elements using a common XPath statement...(read more)...

34 of 457 | Introducing ‘Mockingbird’ - In my previous post, I briefly mentioned a tool that helped with the testing of web-service consumers. I’m happy to announce that this is now publicly available on CodePlex under the moniker “MockingBird’. Here are some details about...(read more)...

35 of 457 | New-ish downloadable BizTalk related resources - List of a few new downloadable posters, whitepapers and help documents. BAM Activity Monitoring in Depth for Developers Using Custom Behaviors with the BizTalk WCF Adapters, part 1 and part 2 BizTalk Server 2009 beta chm , also updated R2 chm BizTalk...(read more)...

36 of 457 | On the ‘Opacity’ of Orchestrations - Richard Hallgren recently sent me a link to a question that was posted on StackOverflow dealing with “Mocking Web Services consumed by Biztalk Request Response ports” and asked for my thoughts on the subject as BizUnit and BizUnitExtensions...(read more)...

37 of 457 | Version 10 of the Message Box Viewer Tool (MsgBoxViewer) Release - Just a quick note to those that frequently use the tool (like me) while analyzing and gathering details from a BizTalk Server environment: I’ve just noticed that Jean-Pierre Auconie has released version 10 of his extremely useful Message Box Viewer tool...(read more)...

38 of 457 | Query Notification Capability in WCF SQL Adapter - I recently had a chance to investigate the new SQL Adapter that ships with BizTalk Server 2009 (as part of the BizTalk Adapter Pack) and wanted to highlight one of the most interesting features. There are lots of things to love about the new adapter over...(read more)...

39 of 457 | Query Notification Capability in WCF SQL Adapter - I recently had a chance to investigate the new SQL Adapter that ships with BizTalk Server 2009 (as part of the BizTalk Adapter Pack) and wanted to highlight one of the most interesting features. There are lots of things to love about the new adapter over...(read more)...

40 of 457 | AdapterConfig – what is it and how does it help me - I was currently developing the Bulk XML import adapter and I had developed the adapter and tested it on my development box. I then proceeded to create the MSI. So you go and create the code for the adapter, and test the functionality of the logic. After...(read more)...

41 of 457 | Orchestration Designer Crash - I recently encountered a troubling problem while creating a BizTalk 2006 R2 solution. Everything was working fine until I tried to open the Orchestration Designer to edit one of the orchestrations I had been working of for a couple of days. Visual Studio...(read more)...

42 of 457 | Viewing tracking and archived data in BizTalk Server 2009 (beta) - There have been some great posts so far on the new features included in BizTalk Server 2009 beta. For example: Richard Seroter’s overview of new features, Michael Stephenson’s BizTalk Testing Guide on 2009,  Steef-Jan Wiggers’s building a sandbox...(read more)...

43 of 457 | Busy travelling, busy speaking… -   So, I’ve been booked into the Microsoft 2009 SOA conference in Redmond at the end of this month to speak about the new version of the ESB Guidance (V2.0). For those of you who are familiar with version 1.0 of the guidance, I strongly recommend...(read more)...

44 of 457 | A Quick Walkthrough of the BizTalk 2006 R2 Upgrade to BizTalk 2009 - Originally posted by Nick Heppleston at: http://www.modhul.com/2009/01/04/upgrading-biztalk-server-2006-r2-to-biztalk-server-2009/ In this post, I’ll quickly walk through upgrading a production BizTalk 2006 R2 installation to the latest BizTalk...(read more)...

45 of 457 | SQL Connection Information for BizTalk Adapters - I created a SQL Bulk load adapter as the standard SQL Adapter casts the stream to a string and runs out of memory for large datasets. While developing the Bulk Load adapter, I need to specify the connection information. I was about to implement a custom...(read more)...

46 of 457 | Happy New Year BizTalk-ers! - Just a quick post to say Happy New Year to all of the BizTalk community. I was planning on writing about the BizTalk 2006 R2 to 2009 upgrade experience, but I managed to forget my external drive so I can’t start the VM… instead you’ll...(read more)...

47 of 457 | Failed to create the transport adapter - I have received this error when testing my adapter I am creating: The Messaging Engine failed to create the transport adapter "SQLBulkXML". OutboundAssemblyPath: "D:\Eric\Warehouse\Adapter\Run-Time\SQLBulkXMLTransmit\bin\Debug\SQLBulkXMLTransmitAdapter...(read more)...

48 of 457 | BizTalk Server 2009 MSBuild Tasks - I’ve been looking around the new project system introduced in the BizTalk Server 2009 beta. As you might have heard before, it’s now based on MSBuild. This is an extremely welcome change from the obscure compilation model in previous BizTalk versions...(read more)...

49 of 457 | PipelineTesting and BizTalk 2009 - Now that the a public beta release of BizTalk Server 2009 is out, I thought I’d download it and try building and testing PipelineTesting on the new release. After downloading and installing the beta, I proceeded to import the existing Visual Studio 2005...(read more)...

50 of 457 | I'm in .iso installation hell - I've been installing a new VPC with Windows 2008, SQL Server 2008, Visual Studio 2008 and BizTalk Server 2009. I've never had so much trouble installing from .iso files. It seems to work 1 out of 5 times, or less. Even when you try the same file...(read more)...