Stupid, Stupid, Stupid… Me!

,
November 14, 2007 / No Comment

I hate to admit that I have been plagued by this stupid BizTalk error for weeks now.  I must say that I haven’t been focusing on this particular issue the entire time, but when I did it wasn’t pretty.  I was never able to wrap my head around the problem, and even worse, the solution.  Until…
The error:
MyOrchestration.odx(783,59): error […]
Read more

AUTHOR: CATEGORY: BizTalk

Something brewing… Not ready for Prime Time.

,
September 13, 2007 / No Comment

It’s been quiet on the blogging front for awhile.  Things have been pretty quiet at work and nothing of great value has been discovered.  I have been playing with WPF and WCF a bit.  I hooked up BTS 2006 to a WCF Send Port which was pretty cool.  I didn’t think the transport properties form was very “friendly”.  There were […]
Read more

AUTHOR: CATEGORY: .Net, Adapters, BizTalk, LINQ, WCF, WPF

PGP Pipeline Component v1.1

,
August 7, 2007 / 9 Comments

I ran across a few things that I needed to update and have posted them here as well.
Notable changes include:

Added Pipeline Component property of Extension.  This allows you to specify what extension you want to place at the end of your encrypted file.  The default value is PGP.
Added capability to decrypt a signed message.
Updated decryption to […]
Read more

FTP, PGP, and Me

,
August 7, 2007 / No Comment

So let me break this down for you…
Company A (Acme, Inc) wants to exchange data with Company C (Charlie Company).  However, I represent Company B (BizTalk United) and we want to collect some of the data as well.  A requirement has been made that all data will be transmitted using FTP and will also be encrypted.  So, as the […]
Read more

PGP Pipeline Component

,
August 7, 2007 / 27 Comments

Recently I was required to perform some PGP encryption and decryption of files.  Realizing this was going to require a custom Pipeline Component, off I went to Google to find one.  Hey, why reinvent the wheel.
I’m not certain why Microsoft didn’t put one in place with the release of BTS 2006, but who am I to judge. :)
The ones […]
Read more

Search and Replace Pipeline Component

,
August 7, 2007 / 1 Comment

Ok. So this isn’t the fanciest of things, but it really saved my bacon.
Problem: I have a predefined flat file schema to transform a fixed-length positional file. However, for some unknown reason, random records in the file extend beyond extend beyond the specified record length. I was able to deduce that those records consistently contained a certain value instead […]
Read more

The Curse of the Dollar Sign ($)

,
August 7, 2007 / No Comment

Recently, I was working on a project that inserted records from a flat file in to a SQL table. For the most part, this was pretty simple and straight forward.

Create Flat File Schema (using the wizard)
Create SQL Insert Schema (again, using the wizard)
Create Mapping between file and SQL schemas.

This was only slightly trickier as […]
Read more

AUTHOR: CATEGORY: BizTalk

BizTalk LOB Whitepapers

,
August 7, 2007 / No Comment

Earlier in the year, I published a couple of Whitepapers for Microsoft on the topic of using the BizTalk PeopleSoft and Siebel LOB Adapters. Since then, I have run across a few other helpful pieces of information that I thought I might share in future posts. For now, here are the links to the papers.

Link to BizTalk Server […]
Read more

AUTHOR: CATEGORY: Adapters, BizTalk