Site Archives

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

Posted by Dmitriy Gitelman on October 25th, 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 [...]

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

Posted by Dmitriy Gitelman on October 25th, 2007

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 [...]

Import flat file using BizTalk server

Posted by Leo Wang on October 15th, 2007

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 [...]