|
Home > Archive > BizTalk Server General > July 2004 > can a source schema insert more than one row into the table destination schema is coor
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 |
can a source schema insert more than one row into the table destination schema is coor
|
|
|
| source schema:
Field1
Field2
Field3
Field4
Field5
Field6
Field7
Field8
Field9
Field10
Destination schema:
Earnings
Date
I need to do a mapping in order to insert 10 rows into the table
destination schema is cooresponding to. ideally, I hope by the mapping,
after running an orchestration, I can see 10 rows in destination tables
like the following data:
Earning Date
Field1 ****
Field2 ****
Field3 ****
Field4 ****
Field5 ****
Field6 ****
Field7 ****
Field8 ****
Field9 ****
Field10 ****
how to accomplish it ? how to create the special mapping from source schema
to destination schema? i hope i explained the question clearly.
Thanks,
Michelle
| |
| Tatyana Yakushev [MSFT] 2004-07-29, 5:51 pm |
| I'm not sure I understand your question. Can you provide input and output XML?
Usually if you need to create multiple occurences of the same node at the target from several different nodes at the source, you need to drop looping functoid, connect it to
those several nodes at the source and that one node at the target.
Thanks,
Tatyana
--------------------
>From: "M W" <dont@got.one>
>Subject: can a source schema insert more than one row into the table destination schema is cooresponding to?
>Date: Thu, 29 Jul 2004 12:11:02 -0600
>Lines: 44
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
>Message-ID: <#1$cpdZdEHA.712@TK2MSFTNGP09.phx.gbl>
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: s142-179-147-100.ab.hsia.telus.net 142.179.147.100
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:18059
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>source schema:
>
>Field1
>Field2
>Field3
>Field4
>Field5
>Field6
>Field7
>Field8
>Field9
>Field10
>
>Destination schema:
>
>Earnings
>Date
>
>I need to do a mapping in order to insert 10 rows into the table
>destination schema is cooresponding to. ideally, I hope by the mapping,
>after running an orchestration, I can see 10 rows in destination tables
>like the following data:
>Earning Date
>Field1 ****
>Field2 ****
>Field3 ****
>Field4 ****
>Field5 ****
>Field6 ****
>Field7 ****
>Field8 ****
>Field9 ****
>Field10 ****
>
>
>how to accomplish it ? how to create the special mapping from source schema
>to destination schema? i hope i explained the question clearly.
>
>Thanks,
>
>Michelle
>
>
>
>
--
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.
|
|
|
|
|