Forum Replies Created
-
AuthorPosts
-
The problem was very simple … the string expression on the sendport should not contain quotes or double quotes. Its a little bit differnet than filter expressions on receive shapes within orchetsrations (i.e. BTS.ReceivePortName == ‘ MyRecPort ‘ should be BTS.ReceivePortName == MyRecPort. Who woulda thot!
Great, this solution worked perfectly. I had exactly this solution mapped with one glaring difference and that was not using the flattening value mapper.
Once again, I thank you for your help.
FC
Thank you for your response. I have downloaded what I believe you have set up for me and will take a look at it and post a response regardless. I sure appreciate you taking time on this.
FC
Hi Steven,
The other solution that comes to mind is to redesign your web service (if that is possible) using a Contract-First approach. You can download and install the WSCF toolkit from this site:
http://www.thinktecture.com/resourcearchive/tools-and-software/wscf
They also have a walkthrough showing you how to design a web service using the toolkit. Basically, when you build such a web service, the WSDL will expose the underlying message schema, and when you consume the web service in your BizTalk project using a web reference, your Reference.map object (in the generated proxy) will expose a Reference.xsd schema, which will show up in your BizTalk map’s list of available schemas.
Hope this helps,
Daniel.
Hi, Daniel
I have the same problem. But I use biztalk 2006 (not R2). Do you have other solutions for this problem without Biztalk 2006 R2.
Waite for your response soon!!! Thanks!
Steven.
January 15, 2010 at 2:20 AM in reply to: can biztalk read data from csv file,tab file,partial data from multiple text files, ssh tunnel and send to sql server DB #24079What’s the QCF SQL adapter?
thanx a lot, i’m gonna try this, but perhaps not with a netnamedpipe, i’ll tell you how it works.
They’re on Codeplex at … http://www.codeplex.com/Wikipage?ProjectName=SqlServerSamples
Hi Frank,
I have a solution in mind for you, the only thing is that using your input data above, the target schema will not show the elements outputfield3 and outputfield4 (but still have Description 3 and Description 4 in the data).
I have the schemas, map and XML files (for testing) in a zipped file but can’t post it here in the forums. If you are interested in it, go to my profile and you can download that zipped file from there and incorporate those artifacts in your own project…
Daniel.
Hi,
Check the following MS publication to see if that answers your question(s):
http://technet.microsoft.com/en-us/library/bb226478(BTS.20).aspx?wt.svl=prodtechnol
Daniel.
January 14, 2010 at 5:12 AM in reply to: What is the correct way to install the WCF LOB Adapter SDK #24068Just found the answer:
I must install the Adapter Pack SDK SP2 before installing the WC LOB Adapter Packs
I had the same situation.
I created a message of type XmlDocument. Set my receive shape to expect that message. I put a filter on the receive shape to accept messages with the types I wanted.
I then added a decide shape that decides based on the message type to do necessary transformation.
I worked like a charm.
I used biztalk 2006, and I think I will use biztalk 2006R2.
Thanks so much!!!
Huuithut
what about a loop? read the 1 msg and rout it to orchestration1 depend msgtyp, read the 2 msg and rout it to orchestration2 depend msgtyp.
PaPaLeE
Hi,
If you are using BizTalk version 2006 R2, one workaround solution would be to consume this web service in your VS project by using the “Consume WCF Service” wizard when you right-click on your project in Solution Exlorer and select Add -> Add Generated Items..
In the Metadata Source step in the wizard, make sure to choose Metadata Exchange (MEX) endpoint.
The end result is that the wizard will produce an XSD file in your project that represents the signature of your web service method(s), so that you can use that schema in a map in your project.
Hope this helps,
Daniel.
-
AuthorPosts