I am not sure if I ask the right question, but this is the scenario I am trying to run: Multiple files (XML and a few related files, "attachments") have to get into BizTalk as a single message. I have looked into existing adapters, and don't see that done with existing once. To be more accurate, files are taken from file system. Files a...
When using the mainframe DB2 adapter for Microsoft BizTalk 2009, is there any way to get the generated schema to contain all the columns in the result set? We get a simple schema generated, the response contains a record/element called "ResultSets" with a data structure of 'xs:anyType'. If I recall, this works okay in MS/SQL server ...
When looking at http://msdn.microsoft.com/en-us/library/aa560648%28BTS.10%29.aspx I couldn't find BCC or Priority, so I'm sure it's not supported. But why ? ...
We are currently building out a Production BizTalk environment for high availablity. We have built out several dev and qa environments without issue, but non of these have been load balanced or clustered. Should the BizTalk 2009 Production environment be Windows Clustered? According to the below Microsoft Tech Poster, it should be load ...
i have the most annoying issue; i have an orchestration doing a lookup against a view. it works in locally and on our development server, but not in QA or UAT. same code. same views. just different environments. to test this and be sure it's not a coding issue i take my local BizTalk, configure the port to Server A, fire a message and ...
Hi, I'm currently responsible for putting up a multi environment BizTalk Deployment and we're planning on deploying two or more BizTalk Server in a BizTalk Group to provide High Availability and Scalability. Our concern now is how to handle concurrency for adapters like WCF SQL and File Adapters because it is likely possible for exampl...
We are looking into the possibility of upgrading to Team Foundation Server 2008 for our development team. One of our primary reasons is some of the deployment capabilities surrounding BizTalk 2009, but I am curious what other benefits there are for other projects outside of BizTalk. Some of our interests so far are moving to a one click...
I am using BizTalk 2009 and I have a flat file that is similar to the following "0162892172","TIM ","LastName ","760 "," ","COMANCHE ","LN " "0143248282","GEORGE ","LastName ","625 "," ","ENID ","AVE " When I parse it and start mapping it I need to get rid of the quotation marks. I have marked the Wrap Character ...
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 ...
I'm trying to configure automated build of BizTalk 2009 projects using Team Foundation Server 2008. We have a staging server which has BizTalk 2009 installed. I ran the Team Foundation Server Build Setup on this server, and it can build non-BizTalk projects OK. However, BizTalk projects fail to build. I suspected something was amiss whe...
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...
This may be a terribly uninformed question, brace yourself. A company I'm working with has given an 'API' that I can use to access orders, however, there are only two real commands, getorders and getorderdetails. These commands are put in the format of www.server.com/path/to/the/orderapi/getorders/UniqueKey/ If I go to that web address...
I'm building a back-end application that needs to fetch data on various schedules from over 50+ 3rd party web services and that number will continue to grow. The data from these services can currently be grouped into 3 types so each response needs to be mapped to 1 of 3 known schemas. Writing custom c# to hit each web service appears to...
Hi, Our client sends us a flat file as input, which we then take and convert to an XML file before sending to the destination system. The flat file consists of multiple lines, each line is delimited by LF or CRLF. How do I create a Flat File Schema so that Biztalk can interpret each line of data regardless of whether the line was deli...
Hi, We are planning a Biztalk 2009 set up in which we have 2 Biztalk Application Servers and 2 DB Servers (DB servers being in an Active/Passive Cluster). All servers are running Windows Server 2008 R2. As part of our application, we will have incoming traffic via the MSMQ, FILE and SOAP adapters. We also have a requirement for High-av...
Can we have ESB Toolkit 2.0 to route the incoming messages to WCF services hosted in IIS? I'm thinking of using content based routing, validation and transformation capabilities of ESB for WCF services. Thanks ...
We have biztalk group consisting of three servers. We have installed BAM tool on all thee servers. Now for BAM Portal site can we make network load balance using two server from biztalk groups? ...
Hi, From what I understand, in order to achieve MSMQ load-balancing, one must use a technology such as NLB. And in order to achieve MSMQ high-availability, one must cluster the related Biztalk Host (and hence the underlying servers have to be in a cluster themselves). Yet, according to Microsoft Documentation, NLB and FailOver Cluste...
Hello, I would like to know how to detect that a node is not present in the origin. I have tried hundreds of things with the logical functoids with no success. The third case of this page is what I am looking for: http://danshultz.blogspot.com/2007/08/logical-existence-isnil-empty-string.html Thanks in advance. ...
I'm using biztalk 2009 and trying to deploy via vs.net 2008. My project is just an empty BizTalk application with an empty orchestration. I've created a strong name key file and selected it in the Project properties under "Signing". I've also specified an application name. When I deploy I get the error: Error 1 Failed while Updating ...