can a source schema insert more than one row into the table destination schema is coor
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server General > can a source schema insert more than one row into the table destination schema is coor




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    can a source schema insert more than one row into the table destination schema is coor  
M W


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
07-29-04 10:51 PM

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








[ Post a follow-up to this message ]



    RE: can a source schema insert more than one row into the table destination schema is  
Tatyana Yakushev [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
07-29-04 10:51 PM

I'm not sure I understand your question. Can you provide input and output XM
L?

Usually if you need to create multiple occurences of the same node at the ta
rget from several different nodes at the source, you need to drop looping fu
nctoid, 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 destin
ation 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!TK2MS
FTNGP08.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 mess
age are best directed to the newsgroup/thread from which they originated.






[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 11:33 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register