Geeks With Blogs
Evan Koch Musings on BizTalk Server and SQL Server September 2007 Entries
Consumimg Web Services in BizTalk
Sometimes when developing orchestrations in BizTalk it can be useful to be able to communicate with web services. For this example I’ll be calling a web service to generate a MIN for a loan based on the organizationID and sequence number that are passed in as parameters. Below is the definition for the web method: The incoming message that activates the orchestration will contain the organizationID and the sequence number. An example of the input message is provided below. To communicate with the ......

Posted On Wednesday, September 26, 2007 2:25 PM

SSIS and Unstructured Flat Files
Recently I worked with another consultant on trying to import data from a flat file into a SQL Server 2005 database. There were issues loading the file using the SSIS Import and Export Wizard, however, because not all of the rows in the file had the same number of columns. This wouldn't have been an issue using the SQL Server 2000 DTS Import but this functionality has been modified in the new version of SQL Server. Below is the best answer I could find as to why: The simple answer to the question ......

Posted On Wednesday, September 19, 2007 6:30 AM

BizTalk Map Labeling Utility
Anyone that’s worked with a BizTalk map of sufficient complexity is familiar with the pains of making changes to a map. Most maps look like a rat’s nest of links and it can be quite the challenge to find the link for which you’re looking. It helps greatly if the links are labeled, but while labeling links seems to be a best practice, it can also be an extremely tedious practice. I wrote this utility with that in mind, trying to ease the tedious practice of labeling all the links in a map. The utility ......

Posted On Monday, September 10, 2007 10:13 PM

Correlation Sets
When implementing business processes with BizTalk, sometimes there's a need for manual intervention within an orchestration and you can’t predict when this intervention will occur. Let’s work with the process depicted below. The orchestration representation for this matches the diagram fairly closely. The Decide shape and the associated branches are visual representations of if/else logic. The following is analogous: If (CreditScore > 700) Construct Loan Decision (Approve) ElseIf (CreditScore ......

Posted On Wednesday, September 5, 2007 10:00 PM

Copyright © Evan Koch | Powered by: