I have a Stored Procedure on 'xyz server' , Using BizTalk I have to generate Flat file.
How can I achieve
Technology Tips and News
I have a Stored Procedure on 'xyz server' , Using BizTalk I have to generate Flat file.
How can I achieve
Hi,
You need to follow the below mentioned steps to achieve this scenario:
Please indicate "Mark as Answer" or "Mark as Helpful" if this post has answered the question
Rahul
Hi,
you can call a pipeline in Orchestration for converting XML to flat file.
While calling the pipeline in Orchestration, you will be use the code something similar to the following:
Microsoft.XLANGs.Pipeline.XLANGPipelineManager.ExecuteSendPipeline(typeof(YourSendPipelineWhichConvertXML2FlatFile), SendPipelineInput, YourOutputMessage);
Though the output of calling the pipeline is going to be flat file, while declaring the variable of your output message type, you have to declare the variable type as "System.Xml.XmlDocument". So in the above code "yourOutputMessage" is of the type "System.Xml.XmlDocument". For a sample, read this article where the authors uses a scenario to show how you can achieve this requirement.
Code for the article is available here (this is not mentioned in the article)
http://abdulrafaysbiztalk.wordpress.com/files/2009/06/processingflatfiles.doc
Thanks
Hello Rahul,
The Stored procedure will get triggered with the configurations(Connection string, Action Mapping) at the SQL Adapter.
The Stored procedure will get triggered with the configurations(Connection string, Action Mapping) at the SQL Adapter.
Once you get the message inside the Orchestration ,it can be converted to flat file .
You can decide the approach to convert xml into flatfile using Orchestration
Thanks
Abhishek
Hi,
Please follow below steps and refereed useful links to achieve your scenario,
1. Generate schema using WCF-SQL Adapter for BizTalk. that will be your input schema. Please refer below links for reference,
https://msdn.microsoft.com/en-us/library/ee277035(v=bts.10).aspx
How to generate schema using WCF-SQL Adapter for BizTalk
2. Create Flat file schema with flat file wizard. that will be your out put schema.
https://msdn.microsoft.com/en-us/library/aa577898.aspx
Creating Flat File schemas using the BizTalk Server Flat File Schema Wizard
3. Create a map that will transform the result of SP to flat file schema.
The WCF SQL Adapter can Poll the Stored Procedure.
From your history, you've done BizTalk processes before and this is fairly easy.
What have you tried? Are you having a specific problem?
Hi,
you can call a pipeline in Orchestration for converting XML to flat file.
While calling the pipeline in Orchestration, you will be use the code something similar to the following:
Microsoft.XLANGs.Pipeline.XLANGPipelineManager.ExecuteSendPipeline(typeof(YourSendPipelineWhichConvertXML2FlatFile), SendPipelineInput, YourOutputMessage);
Though the output of calling the pipeline is going to be flat file, while declaring the variable of your output message type, you have to declare the variable type as "System.Xml.XmlDocument". So in the above code "yourOutputMessage" is of the type "System.Xml.XmlDocument". For a sample, read this article where the authors uses a scenario to show how you can achieve this requirement.
Code for the article is available here (this is not mentioned in the article)
http://abdulrafaysbiztalk.wordpress.com/files/2009/06/processingflatfiles.doc
Thanks
Hi Jaguarjags,
We can do this using pure messaging only scneario without using orchestration.
Hope that helps
Cheers
You can always specify the polling frequency on the WCF Custom Adapter to trigger the SP any no of times and generate a file every time.
There are many links on google which will provide you with enough information on how you can configure the WCF SQL adapter.
Rahul