|
Home > Archive > BizTalk Server > September 2004 > Reading from a flat file and write to a flat file...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Reading from a flat file and write to a flat file...
|
|
| Madhu Sudhanan R 2004-09-13, 7:47 am |
| Hi,
I want to configure BizTalk Server 2004 / 2002 to read from a flat file and
write the read content to another flat file. The difference that I want to
make here is that I want to reverse the columns and write while writing to
the destination. For example:
Source:
--------
100, NAME 1
101, NAME 2
should be written as follows in the destination flat file.
NAME 1, 100
NAME 2, 101
Hoping for some fast help. Thank you
Madhu Sudhanan R
| |
| Jeff Lynch 2004-09-13, 5:52 pm |
| You should be able to accomplish this in either BTS2002 or BTS2004 using a
simple map.
In BTS2002, you will need to create an inbound and outbound document
specification for your delimited flat files and a map which links the
fields. You will also need to create an inbound and outbound envelope which
points to the document specifications you've created. The inbound envelope
will be used on the receive function (to parse the flat-file into XML) and
the outbound envelope on the channel (to serialize the mapped XML back to a
flat-file).
In BTS2004 it's the same basic concept except you are creating inbound and
outbound flat-file schemas and the map. You may also want to create inbound
and outbound flat-file custom pipelines.
Both the BTS2002 and BTS2004 SDKs have examples of flat-file processing.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/
"Madhu Sudhanan R" <ramanum@fusiontech.com> wrote in message
news:uRs2DVYmEHA.3352@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I want to configure BizTalk Server 2004 / 2002 to read from a flat file
> and write the read content to another flat file. The difference that I
> want to make here is that I want to reverse the columns and write while
> writing to the destination. For example:
>
> Source:
> --------
>
> 100, NAME 1
> 101, NAME 2
>
> should be written as follows in the destination flat file.
>
> NAME 1, 100
> NAME 2, 101
>
> Hoping for some fast help. Thank you
>
> Madhu Sudhanan R
>
| |
| Alan Smith 2004-09-13, 5:52 pm |
| Hi Madhu,
In BizTalk 2004, do this (you don't even need an orchestration!):
1 Create a Flat File Schema for your inbound document.
2 Create a Flat File Schema for your outbound document.
3 Create a map to map the inbound doc to the outbound.
4 Create a receive port, and send port with the map, and configure them to
route the message.
/Alan
"Madhu Sudhanan R" wrote:
> Hi,
>
> I want to configure BizTalk Server 2004 / 2002 to read from a flat file and
> write the read content to another flat file. The difference that I want to
> make here is that I want to reverse the columns and write while writing to
> the destination. For example:
>
> Source:
> --------
>
> 100, NAME 1
> 101, NAME 2
>
> should be written as follows in the destination flat file.
>
> NAME 1, 100
> NAME 2, 101
>
> Hoping for some fast help. Thank you
>
> Madhu Sudhanan R
>
>
>
|
|
|
|
|