biztalk

Update Web Reference in Visual Studio

Hi, I have inherited a web site project that makes use of a number of WCF Web Services hosted on a BizTalk server. We have two environments that I need to deploy this project to, with different URLs for the different BizTalk servers. i.e. In the Staging environment, I need to point the services at xx.xx.xx.101 In the Live environment, ...

Automatically truncate to MaxLength during mapping

I have a schema that has the max length property set on all of its elements, of various size. I am mapping to it and expect that the max length will be exceeded quite often. Is there a way tell BizTalk to automatically truncate without having to go in and manually configure a functoid for each element? Is there a purpose for the max ...

Exception handling in biztalk 2006 R2

Hello I have a Biztalk 2006 R2 project (used with ESB Guidance 1) I am calling from orchstration to a static method in c# code, this method uses a class to load a file data into xlang message body at part 0 When i pass filepath which doesnt exists the inside class catch the exception but dont throw it up (in the static method there is a...

biztalk administration console crash when browsing for folder

Hi, we recently upgraded our biztalk server 2006R2 to SP1. The problem is that we're having some small issues now, for example the administration console crashes when I browse for a folder if I want to make a file send/receive port. Any idea what might cause this problem? i'm having no problems when I browse for a folder with our nor...

Calling SSIS from BizTalk Orchestration

I have a scenario were I need to move a vast amount of data, and I need to use BizTalk to control the flow and contain the business logic. The problem is that BizTalk will not be able to handle the amount of data that needs to be moved. We have decided to a BizTalk Orchestration to kick off an SSIS package that does the actual heavy li...

Replace .sln with MSBuild and wrap contained projects into targets

I'd like to create a MSBuild project that reflects the project dependencies in a solution and wraps the VS projects inside reusable targets. The problem I like solve doing this is to svn-export, build and deploy a specific assembly (and its dependencies) in an BizTalk application. My question is: How can I make the targets for svn-expo...

Biztalk vs API for databroker layer

My company is about to undergo a large project in which our client wants a large customer portal with a cms, crm implementing. This will require interaction with data from multiple sources across our customers business, these sources include XML office backend systems, sql datbases, webservices etc. Our proposed solution would be to wr...

Make a scripting functoid in a BizTalk map skip the output element

I'm using a scripting functoid in a BizTalk map. In a certain case, I want the destination element to be skipped (rather than empty). I'm using inline C#. When I return null, the destination element is empty. Is there a way to make it skipped altogether? ...

Usage of Biztalk SAP Adapter without Biztalk Server to connect .NET and SAP

Is it possible to use the Biztalk adapter pack whithout a Biztalk installation (Biztalk license is available)? I want to use the Biztalk Adapter for SAP RFC calls within a .NET Application (as a replacement of the SAP Connector for .NET, which is unfortunately no longer maintened by SAP and I don't can use third party products like "Er...

Biztalk suspended messages in database

Hi, I was wondering if some1 knows where I can see the data of a suspended message in the biztalk database. I need this because about 900 messages have been suspended because of a validation and I need to edit all of them, resuming isn't possible. I know that info of suspended messages are shown in "BizTalkMsgBoxDb" in the table "Inst...

BizTalk FTP - File Rename

Hi I need to send files using the BizTalk 2006 (non wcf) FTP adapter. After successful transmission of each file it needs to be renamed from an "A" prefix to a "U" prefix. I don't want to issue a command using wildcards because I can't be sure of other files in the destination folder. Any ideas? Thanks Rob. ...

OutOfMemoryException Processing Large File

We are loading a large flat file into BizTalk Server 2006 (Original release, not R2) - about 125 MB. We run a map against it and then take each row and make a call out to a stored procedure. We receive the OutOfMemoryException during orchestration processing, the Windows Service restarts, uses full 2 GB memory, and crashes again. The ...

.odx Files in BizTalk 2009 (VS2008 IDE) Fail to open. "Unspecified Error"

Okay, I'm not sure if this is an SO question, or a ServerFault question, but I figured I'd post here first. I have a BizTalk project which works like a champ for its original design. It's been deployed and it's working fine. Today, I went in to add some new fuctionality by modifying one of my orchestrations. When I attempted to open ...

Call MiSys Equation API from BizTalk

How can I call MiSys Equation API from BizTalk or .NET? Equation is a banking system hosted on ISeries AS/400 server. is the Host Integration server way to go? ...

Schema Inheritance in BizTalk Server

Hi, I just wondering if anyone has already tried of doing something like schema inheritance in BizTalk schemas? I am using WCF Adapter and using 'consume adapter service' to generate a schema automatically, what I wanted is instead of always generating a schema and since most of my schema is the same then I want to have something like ...

Import small number of records from a very large CSV file in Biztalk 2006

I have a Biztalk project that imports an incoming CSV file and dumps it to a database table. The import works fine, but I only need to keep about 200-300 records from a file with upwards of a million rows. My orchestration discards these rows, but the problem is that the flat file I'm importing is still 250MB, and when converted to XML u...

How to keep deployed code on multiple biztalk front ends in sync?

We have multiple Biztalk 2006 application servers, and I find it almost impossible to keep the versions of our projects in sync on them. It's a tedious process of deploying the MSI packages, importing them, matching up files in the GAC, deploying some registry changes, and if one step is missed or somebody deployed an updated copy of a D...

Biztalk Log4Net

Has anyone used log4net with Biztalk? We are currently looking into using it and are trying to access pros/cons, and whether or not it would meet our needs. ...

best practices on accessing BizTalk 2009 hosted services from SharePoint 2010 UI through WCF (publish, subscribe method)

I have a scenario where we have a bunch of Services hosted in BizTalk we want to be able to access it from SharePoint UI (also may be some ASP .Net Applications hosted inside SharePoint. Can any of other have faced similar scenario's can share with the best practices in terms of performance vs maintainability. Since we have to cater S...

Biztalk - local variable in expression shape

Sometimes when I'm writing XLANG/s code in an expression shape, it would be more readable if I could just use a temporary variable within the scope of that one code block. I hate to clutter up the entire orchestration with a variable declaration. Is there a way to declare a variable within an expression shape? ...