May 292008

Have you ever used the search functionality in Windows Explorer, only to be disappointed as it returns no results.  I’ve seen this a million times, and is one of the first settings I change when bring up a server.



Here’s the fix:

set the FilterFilesWithUnknownExtensions DWORD value to 1 in the following registry key:



Restart the computer and search away!

May 202008

Wanted to start writing about our experiences with using the product.

We have just been awarded a contract to enhance some of the functionality in the product.

I don’t have a lot of information about the product other than the Thomson’s product site, some press release information, and Karen Jones singing it’s praises (there are some questionable pictures on this last blog page, so look at it at home!).

Keep your eyes on this Thomson category, as I explore what we are doing and how others might benefit from our enhancements.

By the way, if you have any experiences, feel free to contact me through the blog’s contact page, or you can contact me (Eric) directly on the contact information page, or even feel free to post a comment to this entry.

May 152008

I installed an SP2 upgrade over the weekend on BizTalk 2004.  Here were the take aways.


1.  Always have the BizTalk user account as God mode for the SQL server that hosts the BizTalk Databases.

2.  Shrink the MsgBox and Tracking Databases before installing the SP2 upgrade. ( for the MsgBoxDb and KB894253 for the Tracking DB)

3.  If the database file sizes don’t decrease use the following SQL methods:

dbcc shrinkdatabase(<DatabaseName>)
dbcc shrinkfile (<DatabaseName>, <size in MB>)

May 062008

I’ve created a decode BizTalk Pipeline Component that can replace any character or any string in an inbound file.

Here are some uses for it:

Replace a Trading Partner ID before BizTalk receives the file in the Message Box.

Replace HEX Characters in a flat file.

Insert carriage returns in an EDI file as the Segment Terminator.


In Pipeline Properties choose the characters you’d like to replace in the form of <character to replace>,<replacement character>.  You can replace as many character pairs as you’d like.

In this example I’m replacing » with N and a with w.


Here’s a sample input file:


Here’s the output:


Email me if you would like a copy after referring to this page.