Forum Replies Created
-
AuthorPosts
-
You guys have been great. Works like a charm.
Using Xman71’s link above in conjunction with the following pipeline creation tutorial link I found elsewhere, I was able to get the desired functionality.
This is an excellent tutorial on creating a custom pipeline component if you know nothing about it at all. (ME!, until now) I will say, anyone looking to do this to make sure you use the attached code file on that page because there are some codelines that were not discussed that are in there that you will need. (the encode, decode designation etc)
From there I simply took that code, removed the contents of the Execute method and implanted the code from Xman’s link.
This should be the most concise resource to find this information in one place and hope others will benefit as well.
Thanks to all that helped me out.
Hi,
I don’t have BizTalk 2009, only BizTalk 2006 R2, and don’t have access to the WCF-SQL adapter (licensing issue), so I don’t think I can help you with your request. You might want to try your luck with someone else…
I am looking at someone setting up the sql adapter to send a xml file that we have already have developed through Biztalk to SQL tables. Do you mind me sending me your number or email address and I can call you when you have some time or I can send you mine and you can call me when you have time.
Hi kiethb1,
To follow up and clarify the post from Greg, you need to do two things in your custom Send pipeline artifact, after you have created, compiled and GAC’ed your custom component:
1) Load the custom component into the list of BizTalk Pipeline Components in the Toolbox area in your Visual Studio BizTalk project, and drag and drop it into the Pre-Assemble stage on the Pipeline Designer for your Send Pipeline. Modify the property settings of that component (if applicable).
2) Drag and drop the native Flat file assembler into the Assemble stage on the Pipeline Designer for your Send Pipeline. Modify the property settings of that component (if applicable).
Daniel.
Hi,
It depends on the scope, timeframe and technology involved. Also, there are some logistics issues since I am working full-time.
Also, you can post a job requirement on this site, as there are sections for contract and full-time opportunities.
Hi,
My suggestion would be to have a SAP administrator (if you have one) troubleshoot this issue on the SAP side of things when the message is trying to get through the SAP adapter in BizTalk. Also, you should play around with the settings in the SAP adapter in BizTalk to see if any changes you make would allow the messages to be consumed successfully instead of being dehydrated.
This is my advice to you, and I can’t think of anything else, short of hiring me to help you with the project you are doing (no pun intended).
Daniel.
Daniel thanks for the information. Would you be interested in doing this project?
Hi Jud.Wendel,
I have the exactly same problem with Biztalk 2009 right now. Looks like the orchestration neglects the mapping and uses the source schema for the SQL send port action.
Really hope that you’ve figured out the problem, so I can get the solution from you. Thanks.
Regards,
padres19
Hi Daniel,
Thanks for your reply..
A strange behaviour i noticed that when i get above mentioned error at SAP port the request message gets into dehydrated..i guess while sending messages to SAP there could be some problem..
And when i terminate message and reset it in sql table to again send to SAP it parks sucessfully..
Could you pls advise…
Hi,
You should take a look at the WCF-SQL Adapter, and here’s a blog detailing how to use it in BizTalk 2009:
Hope this helps,
Daniel.
You create a custom pipeline component to perform the file name promotion only.
Then create a custom pipeline, and include both the Flat File Assembler component and your custom component from above. You will probably put you component in the Encode stage of the pipeline.
The pipeline will call each component in the pipeline in the order defined.
If I may, one question that came up was that I am already using a pipeline that is using the flat file assembler… so do I need to create a custom component to incorporate the flatfile assembler code and the code in this thread to accomplish everything I need? I dont see how else to make the pipeline do everything I want since it only allows one assemble component…
Thanks
I have to say that it certainly appears to be. I will see if I can get this to work, but thank you for I believe others will readily find this helpful and consider this thread complete.
Great job.
Hi Kiethb,
Is this what you are looking for?
Daniel.
Greg… I know this was a long time ago, but if you are still around I would really like to know how to create this pipeline to solve this problem without an orchestration.
Seeing how this is one of the first sites that comes up in google, it would be great if a complete answer was here for all that are looking for it.
Thanks, Kiethb
-
AuthorPosts