Encoding - pipelines

Did you know that pipeline-files (*.btp) is XML files ?

I had to change Target charset on a outgoing pipeline. Our problem was to send out files in Dos format (also known as ibm850). But I couldn’t choose codepage 850 in the pipeline designer I Visual Studio.

Strange – In the pipeline designer you can only choose about 20 charsets, but in fact BizTalk is supporting the same charsets as .NET. That means a lot more !

The solution is to open the .btp file in ex. Notepad. Then replace the value under TargetCharset and TargetCodePage. For example:







It worked! Afterwards the right Target charset was showing in the Pipeline designer J

Huge transaction log

I had some problems with a huge transaction log on BizTalkMsgBoxDb – 32 Gb !

Backup was taken directly of the data files, but even if I created a transaction log backup of the database, the file kept growing, The problem was that BizTalk never stopped using the database, sow there was no space to shrink the base after the backup.

The solution was to change the backup job. I added a new step after the backup step: “DBCC SHRINKFILE (BizTalkMsgBoxDb_log, 0)"

But why ?

Hi! - Purpose with this blog is to collect my experiences with BizTalk 2004 and 2006 over the last couple of years. I hope it be helpful to someone!

Best regards-Jørn