Monthly Archives: October 2007

Install BizTalk Server 2006 Orchestration Designer for Business Analysts with Visio 2007

Recently I tried to install BizTalk Server 2006 Orchestration Designer for Business Analysts (ODBA), but the installation failed with this error message.

I had Visio 2007 on my system and it looked like ODBA installer was hard coded to look for Visio 2003. To confirm that, I used Registry Monitor utility from Windows Sysinternals web site [...]

Posted in General | Leave a comment

Handling of Record Tag Identifiers by BizTalk 2006 Flat File Schema Wizard

Those, who work with BizTalk 2006 Flat File Schema Wizard, probably noticed that record tag identifiers are handled differently for delimited and positional records. Let’s use a simple text file Person.txt for this example.

After opening Flat File Schema Wizard, skipping the Welcome Screen and entering required information on Flat File Schema Information screen we are [...]

Posted in General | 1 Comment

Import flat file using BizTalk server

Recently I worked with a client to implement a solution to import data from an Excel file to SQL Server database. In order to provide a seamless user experience, we created a web page to allow user to upload file to server, then use BizTalk server to convert Excel file to XML file and call [...]

Posted in Biztalk Tutorial | 2 Comments