RE: Create one File Output for every input record ???

From: stiffler (stiffler_at_discussions.microsoft.com)
Date: 12/02/04 

Date: Thu, 2 Dec 2004 00:49:01 -0800

Hi David

My Input Data is Flatfile and looks very simple like this:
-----------------
abc 123 xxx
dfg 456 yyy
hij 789 zzz
-----------------
The Records are delimited by a CR LF.
So for each Record i have to create 1 file with only 1 record in it,
therefore the Ouput schould look like this:
File 1 File 2 File 3
---------------- ---------------- -----------------
abc 123 xxx dfg 456 yyy hij 789
zzz
---------------- ---------------- -----------------

What i read in a BizTalk Book ist that Mapping ist always tought to be
between 1 Input and only 1 Output ! Is that true.
I tried to map the input to the same output structure, but changed the max
record accurences to min=0, max=1, but in the output nothing changed then,
all records appeared in the output.

You told me about another solution with envelopes. I could do it also with
this, because i first map flat to flat and then in another channel flat to
xml.
Whats simpler? Do you have a sample how to split uf an xml message into many
whit envelopes.

I can not belife that there are not more people whitch have to split uf
Messages in many Msg's.
Thank you a lot for your help...

greets stiffler

""David Downing [MSFT]"" wrote:

> This will depend alot on the structure of your data. If the data is flat
> file, your schema can be set such that only a single record can exist. If
> the data is XML and has some kind of envelope structure, then you can break
> up the documents using the envelope.
>
> If this did not answer you question, please provide more information on the
> structure of your data... if possible cut/paste it into another post.
>
> Dave
>
> --------------------
> >>Thread-Topic: Create one File Output for every input record ???
> >>thread-index: AcTXAlxpiyv5ya1wQ1uFdJUxRCxddA==
> >>X-WBNR-Posting-Host: 195.183.16.34
> >>From: "=?Utf-8?B?c3RpZmZsZXI=?=" <stiffler@discussions.microsoft.com>
> >>Subject: Create one File Output for every input record ???
> >>Date: Tue, 30 Nov 2004 09:31:01 -0800
> >>Lines: 10
> >>Message-ID: <071D5F0E-26C3-495F-918C-48EF93E249F9@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:
> cpmsftngxa10.phx.gbl!TK2MSFTNGXS01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08
> .phx.gbl!TK2MSFTNGXA03.phx.gbl
> >>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:22066
> >>X-Tomcat-NG: microsoft.public.biztalk.general
> >>
> >>Hi all
> >>I use BizTalk 2002 !
> >>I have a stockItem Business Document with S Item Records in it.
> >>For the target system i need to create for every <item> a file.
> >>So i will have S output files with only one <item> tag.
> >>
> >>Where can i acheive this ? Via Editor or via Mapper ?
> >>
> >>Thanks a lot for helping me !
> >>greets stiffler
> >>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
>
>

Relevant Pages

  • Re: Create one File Output for every input record ???
    ... because i first map flat to flat and then in another channel flat to ... Do you have a sample how to split uf an xml message into many ...
    (microsoft.public.biztalk.general)
  • Re: XML Parsing: , illegal name character
    ... I have also posted the xml message. ... XML message into column of 'xml' datatype in SQL 2005 database. ... XML message has & character in one of the tag value. ...
    (microsoft.public.sqlserver.programming)
  • Re: XML Parsing: , illegal name character
    ... I can confirm that in incoming xml message, there is no space between & and ... I have also posted the xml message. ... XML message has & character in one of the tag value. ...
    (microsoft.public.sqlserver.programming)
  • Re: Generate a file and compress it
    ... You just have to create a send port and associate ... already send a XML file with MQ, you have nothing else to do to send ... Problems is we must take the XML message and write it to a file. ... I want to get a XML document and write the document ...
    (microsoft.public.biztalk.general)
  • Making an XML mess, oh.. message
    ... Trying a XML message by instanitated a class and ... now the receiver dont like my XML and ... I cant solve it nicely.. ...
    (microsoft.public.dotnet.languages.csharp)