biztalk

Generate XSD file without REF elements - I just want a "literal" XSD file

When I use an XML example file to generate an XSD, using both Visual Studio and Oxygen, it generates a file using tons of <xs:element ref="ELEMENTNAME" />, where elementname is an actual element name. Later in the file, it has an element <xs:element name="ELEMENTNAME" type="xs:string" /> where it defines what that element is. For example...

Biztalk Mapping Problem, Ideas please.

Hey folks, I'm working on a moderately complex flat file schema and I've had a curve ball thrown at me. Here's what the input looks like: BCT121,C,7.35,6.5,0.39,7216,"SMITH, TRACEY",13456321,CLASS DRESSMAKING SHOPPE,CLASS DRESSMAKING SHOPPE,VAN,BC,20090109,20090112,20090127,V,0.46, BCT121,C,14.7,13.01,0.78,7216,"SMITH, TRACEY",13456321...

Automatically deploy referenced assembly as "Resource" in VS2005/Biztalk 2006

I have a two-project solution - one project contains my schemas and Biztalk orchestration, and the other contains a DLL that is referenced from my orchestration and does that actual work (it's shared code, so there's no chance I can just incorporate it into the biztalk assembly). The second assembly is added as a reference from the Bizta...

Biztalk alternative for systems management automation?

Hi, I am working with a small hosting provider looking for a "motor" to be the central hub for automation their IT-related processes (and possibly other processes as well. An example of this could be a customer ordering a custom virtual server from their website. This server would need to pass through an approval chain (if it's a new cu...

BizTalk 2006 R2 EDI

Hi guys, I have an working orchestration in place to process X12 messages. Now I need to expose the orchestration as a webservice (ASMX) that accepts a text input (the X12 message) and returns the text response (the X12 response). If I try to use the wizard, the generated webservice will expose the inner XML representation of the X12 re...

BizTalk 2006 SOAP Adapter - Messaging only Web Service Call

In BizTalk 2006, I am trying to set up a messaging-only scenario whereby the recieved message (a string) is passed to a web service method that takes a single string parameter. In other words, the whole body of the BizTalk message should be passed as the parameter to the web service call. The service method looks like this: [WebMetho...

BizTalk 2006 R2 mapping problem

I have this data (all the elements are optional): <data> <optionalElement1>...</optionalElement1> <optionalElement2>...</optionalElement2> <optionalElement3>...</optionalElement3> </data> I need to map this to another schema (all the elements are required): <request> <Element1>...</Element1> <Element2>...</Element2> <Element3>...<...

Reconciling Data in Synchronized Systems

I have a situation where a single Oracle system is the data master for two seperate CRM Systems (PeopleSoft & Siebel). The Oracle system sends CRUD messages to BizTalk for customer data, inventory data, product info and product pricing. BizTalk formats and forwards the messages on to PeopelSoft & Siebel web service interfcaes for actio...

Creating a BizTalk solutions with multiple projects

Has anyone got any guidance, better yet, tools for generating up a "starter" BizTalk solution ? I've been reading various blogs, articles, etc. and they mainly go for splitting down the solution into seperate projects, one for schema, one for orchestrations, etc. I'd like to follow this practice, but it's a pain creating the full set, ...

Biztalk FileAdapter Errror when using Dynamic Send Port and UNC

Hi, I am using a Dynamic Send Port in Biztalk 2006 and i am trying to write to a Windows Share (UNC) but get "Access is denied". The Biztalk host in-process-user got all permission needed at the given folder. I can manually create a new file in the destination but not when using Biztalk. Does the FileAdapter use another host-user ?(wh...

BizTalk deployment including a web reference

Trying out BizTalk with a web service call ... The request/response is working fine on my own dev machine, but not on test ... Exported the MSI over to my deployment test server (a seperate virtual), created the application with the Application/Import and then tested it to find it not working ... - checking the event log and it's show...

Using BizTalk 2006 to join records

All I have a problem I’m trying to solve with BizTalk and was hoping you would have some thoughts on the best way to solve it. I am loading in a flat file using a flat file adapter. This file contains records if a number of different types. Type 1 records are parent records. The rest of the types all link to the parent records using var...

Distinguished field on a web service (BizTalk)

How do you access a field in the message returned by a web service call ? I found Richard Seroters blog post but it says to drill through the Reference.map to the Reference.xsd ... - problem is, I've not got a Reference.xsd - I do have the Reference.map, and the child Reference.odx - I also have the wsdl, but not the disco ...

Adding more promoted properties after a first one in BizTalk

I've got a BizTalk solution where I added a schema, and promoted a field - this added the default PropertySchema.xsd with the element in A bit later, added another schema, but when I try and promote a couple of fields, but when I select Show Promotions, I end up mapping the new field to one of the existing fields in the PropertySchema ...

BizTalk xpath with a default namespace and no prefixes

I'm struggling with the BizTalk xpath functionality - the message I'm getting has a blank default namespace - in C# I'd add a NameSpaceManager - but I can't see how I can do this in a BizTalk Expression ? All I'm failing to do is get the values of the HasErrors and NumberOfErrors <?xml version="1.0" encoding="utf-8"?> <ImportInd...

User permissions for BizTalk server

I've got my dev machine with BizTalk running as local administrator, and I get the warning that it should be ... but I still do But what's the best security group to put the BizTalk user in on a "live" server ? ...

BizTalk mapping to excel

Is there a way to convert or get the mapping from BizTalk map to an excel or a text file. From where we can directly see what field is mapped to what filed instead of following the lines. I have an BizTalk map which had around 600 fields mapped. any pointers will be really helpful. ...

BizTalk server 2006 R2 not using recently "GAC"ced dll .

I have a dll which is "GAC"ced (c:\windows\assembly) which is being used by my Biztalk Application, for some requirement, i changed a function in that dll and 1.i uninstalled the old DLL which was in gac[version was 1.0.0.0] 2.i "GAC"ced the newly built dll into GAC[version is 1.0.0.0] 3.i restarted the BizTalk Host Instances also. b...

Can't terminate BizTalk instances in isolated adapter

Can anyone explain how I can remove service instances ? - I've got a few which the BizTalk console shows as "Running" - they are all in the Isolated Adapter - tried doing a Stop with Full Stop option ... - tried the Terminate Instance option ... - even tried deleting the BizTalk application But they're still there ?? my bad, ...

Pad Rows in BizTalk Flat File Schema

I'm trying to create a BizTalk Schema that looks something like the below (ignore the spaces between the lines- they're only there for clarity.): " x Rows will be inserted Column1^Column2^Column3^Column4^Column5 Data1a^Data2a^Data3a^Data4a^Data5a Data1b^Data2b^Data3a^Data4b^Data5b" So, I have a blank row, followed by a Row count, fol...