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?

[ Post a follow-up to this message ]

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] 

[ Post a follow-up to this message ]