| Author |
Flat file question
|
|
| maverick 2004-10-18, 1:38 pm |
| I have been reading discussions on this board . If the input file is a flat file and we need to map it to a destination, then we can use 2 approaches.
1) We can either develop a flat file schema
or use
2) Flat flat disassembler.
Are the above 2 approaches comletely independent of each other. If yes, then please provide me details about the second option. Also, are there any more options to achieve the above state conversion? | |
| captor 2004-10-18, 1:57 pm |
| Both are not exclusive
You should follow these
1. Add a new Schema (By default it is XML Schema)
2. Change the schema properties to allow flat file extension (i.e. Click on Schema Node, Select Schema editor extensions in properties)
3. Create schema for your flat file (either Positional or delimited)
4. Add a receive pipeline to you solution
5. Add a flat file dissassembler with document type as the schema you created.
Clear? | |
| maverick 2004-10-18, 2:02 pm |
| quote:
Originally posted by captor
Both are not exclusive
You should follow these
1. Add a new Schema (By default it is XML Schema)
2. Change the schema properties to allow flat file extension (i.e. Click on Schema Node, Select Schema editor extensions in properties)
3. Create schema for your flat file (either Positional or delimited)
4. Add a receive pipeline to you solution
5. Add a flat file dissassembler with document type as the schema you created.
Clear?
| |
| maverick 2004-10-18, 2:11 pm |
| quote:
Originally posted by captor
Both are not exclusive
You should follow these
1. Add a new Schema (By default it is XML Schema)
2. Change the schema properties to allow flat file extension (i.e. Click on Schema Node, Select Schema editor extensions in properties)
3. Create schema for your flat file (either Positional or delimited)
4. Add a receive pipeline to you solution
5. Add a flat file dissassembler with document type as the schema you created.
Clear?
Thanks a lot Captor for helping this novice.. | |
| Sukesh Shetty 2004-10-19, 2:47 am |
| Flat file dissassembler parses a flat file schema instance in the pipeline.
Hence the flat file dissassembler would need a flat file schema. And hence
both are not independent.
"maverick" wrote:
>
> I have been reading discussions on this board . If the input file is a
> flat file and we need to map it to a destination, then we can use 2
> approaches.
>
> 1) We can either develop a flat file schema
>
> or use
>
> 2) Flat flat disassembler.
>
> Are the above 2 approaches comletely independent of each other. If yes,
> then please provide me details about the second option. Also, are there
> any more options to achieve the above state conversion?
>
>
>
> --
> maverick
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message437783.html
>
>
| |
| Ruslan Yakushev [MSFT] 2004-10-22, 5:49 pm |
| Right. To be more precise the Flat file disasembler uses flat file schema
to parse documents in flat file format and convert them to XML documents
that adhere to the structure defined in the Flat file schema. Flat file
schema is basically an XML schema with custom annotations that tell
disassembler how to parse data.
--------------------
>Thread-Topic: Flat file question
>thread-index: AcS1rmvxWXBtHnQaTFu//fl9oFQ1BA==
>X-WBNR-Posting-Host: 203.197.24.195
>From: "=?Utf-8?B?U3VrZXNoIFNoZXR0eQ==?="
<SukeshShetty@discussions.microsoft.com>
>References: <maverick.1ecg97@mail.webservertalk.com>
>Subject: RE: Flat file question
>Date: Tue, 19 Oct 2004 00:37:01 -0700
>Lines: 31
>Message-ID: <3ECA73E5-A5E0-4D85-A6E8-0B3AE4F8BD7D@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:20634
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Flat file dissassembler parses a flat file schema instance in the
pipeline.
>Hence the flat file dissassembler would need a flat file schema. And hence
>both are not independent.
>
>"maverick" wrote:
>
>
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this
message are best directed to the newsgroup/thread from which they
originated.
|
|
|
|