BizTalk Server General - receiveing flat files

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > April 2004 > receiveing flat files





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 receiveing flat files
ambs

2004-04-28, 8:36 am

Hi,

I am receiving flat files which i want to convert to xml format using
the flat file disassembler in the receive pipeline.

Now the problem is my flat file comes with data like name, value
pairs.

Will the flat file disassembler be able to ignore the name part and
map just the vaule part with the schema i provide.

below is the sample file...
-------------------------------------------------------------------
# FILE 0325_130045_INS.00000001.00000001

ACTION "INS"
TRANS_ID 1

TBL some name ----> this is meta data
Deals_Id 1 ---------> here Deal_Id is the field name and 1 is
the value
Status V "Valid" ---------> here Status is the field name and V and
"Valid" are values, I am interested in only one of these values
though.
-----------------------------------------------------------------------

can i have a i/p file like this and still use a schema and convert it
to a xml format...
David Downing [MSFT]

2004-04-28, 11:36 am

It would help if you could attach an instance of your file. Looking at what
I think is the file format, it seems likely that we can parse it.

--
Dave

This posting is provided "AS IS" with no warranties, and confers no rights.

"ambs" <ambrish.jhaveri@iflexsolutions.com> wrote in message
news:16f63e0e.0404280403.3c5dd378@posting.google.com...
> Hi,
>
> I am receiving flat files which i want to convert to xml format using
> the flat file disassembler in the receive pipeline.
>
> Now the problem is my flat file comes with data like name, value
> pairs.
>
> Will the flat file disassembler be able to ignore the name part and
> map just the vaule part with the schema i provide.
>
> below is the sample file...
> -------------------------------------------------------------------
> # FILE 0325_130045_INS.00000001.00000001
>
> ACTION "INS"
> TRANS_ID 1
>
> TBL some name ----> this is meta data
> Deals_Id 1 ---------> here Deal_Id is the field name and 1 is
> the value
> Status V "Valid" ---------> here Status is the field name and V and
> "Valid" are values, I am interested in only one of these values
> though.
> -----------------------------------------------------------------------
>
> can i have a i/p file like this and still use a schema and convert it
> to a xml format...



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com