Author Archive

The Curse of the Dollar Sign ($)

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 I had multiple source schemas. Not sure why you must begin those types of maps within the Orchestration editor, but that is another topic.

String it all together inside an Orchestration and deploy.

Things were moving along very well, and due to the simplicity of the integration, I [...]

read more

BizTalk LOB Whitepapers

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 2006 Adapter website: http://msdn2.microsoft.com/en-us/biztalk/aa937652.aspx

Link to PeopleSoft LOB Adapter Whitepaper: http://download.microsoft.com/download/1/6/9/16968441-c6c8-4bd0-9410-5f4014bc61f0/peoplesoft.doc

Link to Siebel LOB Adapter Whitepaper: http://download.microsoft.com/download/1/6/9/16968441-c6c8-4bd0-9410-5f4014bc61f0/siebel.doc

Introduction

Greetings and welcome to my BLOG.

I have been meaning to begin BLOGging for several months now. Well, actually going on a year I suppose. I guess I felt that I really didn’t have anything too terribly important to say. Not that I think that now, but that I have recently run across a few items that I found interesting. I guess I just needed something to get me started. Hopefully, I will have something that will benefit someone, somewhere.

A Little History
I entered the professional world of programming as a COBOL programmer on a WANG mainframe for the USAF. It was [...]

read more

We have engaged IntelliTect on several projects and have been very happy with their service.  They are very flexible and have always been able to accommodate our tight time tables.  We have been impressed with the depth of their knowledge of Team Foundation Server and they have become our trusted advisor for TFS.  I would highly recommend them to anyone needing assistance with Micosoft’s Team Foundation Server.