December 2007 Entries

"Not Exists" Expression Filter

In Biztalk 2004/2006/2006R2 there is the option to set Filters on orchestration receive shapes and send ports. The operands are !=,==,>=,<= and Exists. The Exists is used to check for promoted properties in the message. But what about an operand for "Not Exists"? Take for instance a scenario where an orchestration is subscribing to a certain message type, sets a promoted property in the message, and then returns the message to the message box. Using "Not Exists" would keep the message from ......

Handy SQL Delimited string to XML

I came across this simple yet great way of translating a delimited string to XML using SQL 2005. http://www.sqlservercentral... /* Here is the string that we need to split */ DECLARE @str VARCHAR(100) SET @str = '0001,0002,0003,0004,0005' /* I am converting the string to an XML structure by inserting XML tags. */ DECLARE @x XML SET @x = '<i>' + REPLACE(@str, ',', '</i><i>') + '</i>' /* Now we can apply XQuery to return a resultset */ SELECT x.i.value('.', ......

SQL Excel Opendatasource

Sometimes you want to use Excel as a datasource. Here's a simple SQL statement using OPENDATASOURCE to do just that select *FROM OPENDATASOURCE('Microsoft.J... Source=C:\myWorkbook.xls; Extended properties = Excel 8.0')...[SheetName$] ss ......

BTS2006R2 MSI Deploy

I took my first stab at deploying a BTS2006R2 application from my development machine to another BTS machine. It worked pretty well but a couple of catches. All the catches are in the documentation but I'm going to go through them here. 1. Include any GACed assemblies in the Biztalk Administrator Application Resources. I have some assemblies that are used by custom XSL maps so I have to include these. It's pretty easy to do by right clicking the Resources folder of the application and selecting Add ......

Hello

I finally have a place to blog everyone can see.