|
Home > Archive > BizTalk Server General > December 2004 > BizTalk Mapper -Question
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 |
BizTalk Mapper -Question
|
|
|
| Hi All
In our project we are pulling data from a Data Source that has 400+
columns, but we use only 125 of them. The column mapping looks something
like this
=======================================
Source Table : Destination (SQL Table)
=======================================
Field1 = Column1
Field2 =
Field3 =
Field4 =
Field5 =
Field6 =
Field7 =
Field8 = Column2
.....
Field400 = Column125
In the above mapping, "Field2" to "Field7" are there in the Source, but
it's redundant for us.
When we do this mapping in "BizTalk Mapper" the UI looked really ugly (due
to 400 columns), so we thought of create a "GROUP" of un-used columns
something like this
=======================================
Source Table : Destination (SQL Table)
=======================================
Field1 = Column1
GRP-Field2-Field7 =
Field8 = Column2
.....
Field400 = Column128
If we do so we get the following error when we compile the project.
1. Attribute fields must come before all element fields and records in a
single record.
2. Record "Root" - The Child Delimiter Type property is not set for a
delimited record.
The way we have defined the Schema is
<Root>
Attribute1
<Child Record>
Attribute2
Attribute3
Attribute4
Attribute5
Attribute6
Attribute7
Attribute8
.....
Any help please?
| |
| Tan Bao Nguyen 2004-12-22, 5:52 pm |
| Did you resolve the schema issue? If not, could you send me your schemas
and map?
Regards,
Tan Nguyen
Microsoft BizTalk Server
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------[vbcol=seagreen]
< 7204cebfe343c8cd26d3c32d3258ef5b@localho
st.talkaboutsoftware.com>[vbcol=seagreen]
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onlin
e.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!sn-xit-03!sn-xit-06!sn-
post-01!supernews.com!corp.supernews.com!not-for-mail[vbcol=seagreen]
|
|
|
|
|