Re: receiveing flat files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David Downing [MSFT] (ddowning_at_online.microsoft.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 08:35:00 -0700

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...

Relevant Pages

  • Re: Trying to export flat file
    ... I tried building that in a macro, using text format instead of XLS, and I get ... the same thing as if I export with the File->Export command, ... > Substitute your own query name and the name you want for the export file. ... >>I am trying to export a flat file of data, ...
    (microsoft.public.access.gettingstarted)
  • Re: SSIS - Flat Files
    ... format files through the SSIS Designer. ... current import tool - these are stored as csv files that specify column ... Is there an easy method to create a flat file connection from these format ...
    (microsoft.public.sqlserver.dts)
  • Re: convert from char(6) to datetime
    ... using one of the format codes ... I receive a very much unstructured flat file, which I import into a SQL ... one of the flat file columns is ... "The conversion of char data type to smalldatetime data type resulted in an ...
    (microsoft.public.sqlserver.connect)
  • Outbound flatfiles
    ... flat files and XML into a canonical XML format so rules can be applied ... documents in a specific flatfile format. ... assembler applies a flat file schema and presumably the document is ...
    (microsoft.public.biztalk.general)
  • Re: port binding in flat file receive sample
    ... You can treat the flat file assembler/disassembler the same way you would ... format for the disassembler is flat file, and the destination format for the ... > 1)i did not undestand how output port got binded to the orchestration. ...
    (microsoft.public.biztalk.general)