- This topic has 2 replies, 1 voice, and was last updated 3 years, 5 months ago by
.
-
Posts
-
-
I have a case in which reports generated from the SAP server will be placed in a source folder and they have to be sent to the destination folder; in short – a file –> file case. I have succeeded in making this happen by creating an application directly in Biztalk Administration and then completing the formalities. Please note that there is no schema for the reports as they are non-uniform; and hence, Visual Studio was not called upon.
En route to completion, I have to update a SQL database table after getting the results in the destination folder based on the report name. I know that a stored procedure will have to be called, but how is that to be done as there is NO schema?
Looking forward to a good solution…
Thanks in advance…
-
Hi Abhishek,
You will have to implement content-based routing by creating a custom pipeline component and using it in the receive location where the SAP-generated reports are received. Check out the following BizTalkGurus blog on how to implement such a pattern:
Please note that the blog describes a messaging only scenario that calls a web service, but you can reuse the information on creating the custom pipeline component and the general idea remains the same.
Daniel.
-
The Dirty Girls Social Club • Alisa Valdés-Rodríguez • 9781250765864
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.