- This topic has 2 replies, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
Hello
I have been tasked with creating a Biztalk process that extracts data from an SQL server and then creates a csv file and puts it into an FTP directory.
I have managed to create a process that gets the data from the database using an SQL Stored Procedure but how do I create a csv file that can be printed out from the results of the SP. I’m thinking of writing some custom C# or something but a point in the right direction would be appreciated.Regards
JMan -
You can achieve this by Multipart message. Request is SP call and Response is data from SP in a form xml document. U can map that outputted data in any form you want.
Mohit
-
I’m not sure why you need a multi-part message.
There should be steps elsewhere in this forum of how to use the SQL adapter. You will have to write an orchestration to call the SQL adapter with a send and receive the result back (use a request/response type of send port).
Then you can create a \”flat file\” schema. Flat files schemas can be either CSV or positional. I’m not sure where instructions are on how to build this type of schema – but it’s probably on the web somewhere (I have also have a video on this topic and the SQL adapter on my website below.)
Then in your orchestration, map the response from SQL to the flat file schema and send it to a flat file send port (or maybe even an FTP send port). Biztalk process userid will have to write access to the output file directory.
Neal Walters
http://Biztalk-Training.com – Learn Biztalk Faster
http://Sharepoint-Training.com – End-User Videos
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.