- This topic has 1 reply, 1 voice, and was last updated 9 years, 5 months ago by
.
-
Posts
-
-
Hi
The scenario I have is to integrate 2 systems. The 1st system sends a csv file to the 2nd system. My first question is this: I know that BizTalk can accept a csv file as input, then convert to XML etc for processing within BizTalk, but can it then output the same data as a CSV file?
System 2 currently has a manual process, which basically involves running an exe or shell script of some sort. My second question is: Can BizTalk instruct the second system to run this exe/shell script?
Cheers
-
Scenario 1: Interesting – so you want to keep a copy of the CSV file as it is and then also process it as XML?
To get the flat file parsed, you have to build a custom pipeline, and you must specify the pipeline on the receive port.
So maybe you could receive the file with a Pass-Thru pipeline, then to get a copy of it, have to Send Ports subscribe to it. Then you would have a receive port with the Flat-File Disassembler Pipeline grab the file from one of the two output locations.
Anyway, that’s my first thought off the top of my head.
The other alternative is to translate it back to the CSV – Biztalk can do that, but then you have to create a FlatFile Send Pipeline.
Second Question:
I don’t think Biztalk by itself can do that, but you might look into writing a C# program that does WMI (Windows Management Instrumentation), then Biztalk coudl call the C# (as a Static C# Function).Neal
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.