Partial row at end of file - best way to handle?

Hi,

I have a file where there is a partial row at the end. It doesn't cause an error, but I get a "partial row" warning during execution.

What do most people do with these partial rows? Do they just ignore them as long as they don't cause errors? Or is it better to handle the partial row with a conditional split, for example?

Just wondering what other people's thoughts on this are. I tend to be of the "get rid of it" camp, but maybe that's overkill? Just looking for opinions, best practices.

Thanks

Hi Sadie,

I'm not sure I know what you mean. Can you paste the last few lines of the file up here? Also, tell us how you have the connection manager configured (i.e. delimited, fixed-length etc...)

-Jamie

|||

Data:

col1, col2, col3, col4, etc

col1, col2, col3, col4, etc

col1, col2, col3, col4, etc

col1, col2, col3, col4, etc

col1 --> partial row

This gives a warning, but doesn't cause an error.

Comma delimited conn mgr.

|||Is it always the last row, or can it be in the middle?|||

It's only the last row.

If you have partial rows in the middle of the file, this causes an error (unless you're ignoring errors). But SSIS ignores the partial row at the very end without any special error handling.

|||

sadie519590 wrote:

It's only the last row.

If you have partial rows in the middle of the file, this causes an error (unless you're ignoring errors). But SSIS ignores the partial row at the very end without any special error handling.

Then you can leave it. No harm, no foul. Why is the last row incomplete though? Can it be fixed at the source?|||

Can't be fixed at the source, these are automatically generated extracts that get automatically ftp'd and loaded.

Which goes back to my original question:

What is the best practice for handling these partial rows at the end of file?

If they're ignored, SSIS gives a warning, but no errors. So the package still runs.

But I can also add a conditional split to remove it, which is extra work, but ensures all junk rows are removed.

I was just wondering what other people do with these partial end of file rows?

|||Is the row a footer or something? What makes it "partial"?

I don't accept "bad" files for input into SSIS. Unless the mandate is given from above, I consider files like this to be bad and those who build it need to fix it.

With that said, it's up to you. I don't think there is a best practice. Use whatever you're comfortable with. If you log warnings, and get tired of sifting through them, then perhaps you want to graciously handle the bad rows.|||Yes, these are footers, not bad rows, per se.|||Not sure there is a best practice on this, as Phil said. If it is not causing a problem, I'd leave it.

Parse SQL Statements

Hi.

Does anyone come across this error message whenever u try to parse ANY SQL statements in Management Studio 2005 (even parsing SELECT GETDATE() fails)...

>>>

.Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
>>>

Thks!

See this KB article Yogi, I'm assuming it's the problem you're seeing:

http://support.microsoft.com/kb/910416

HTH

parent/child table error in sqlxml

When I try to select with sqlxml I recevie the following error related to on
e
relationship that has a composite key (all none composite key relationships
work).
Schema: the parent/child table of the relationship on
'ProductMetricsBreakDown' does not match.
The xsd is included that is causing the error is included
It is the AnnualBusinessModel_ProductMetricsBreakD
own that is giving me the
error.
Any help would be greatly appreciated.
<?xml version="1.0" encoding="utf-8"?>
<xs:schema elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name=" MicrosoftPartnerProfile_AnnualBusinessMo
del"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="AnnualBusinessModel" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_Branch"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFocus
"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_FormUI"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_LinksToOtherDocu
ments"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="LinksToOtherDocuments" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_NotesAndConditio
ns"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="NotesAndConditions" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerAssessmen
t"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerAssessment" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerCompetenc
y"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerCompetency" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerIndustryV
ertical"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerIndustryVertical" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerSalesVert
ical"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerSalesVertical" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_PartnerSpecializ
ation"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerSpecialization" child-key="AccountID" />
<sql:relationship name=" MicrosoftPartnerProfile_RevenueBreakdown
"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="RevenueBreakdown" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_Contact"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
child-key="AccountID" />
<sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
<!--<sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
parent="AnnualBusinessModel" parent-key="CalendarYear"
child="ProductMetricsBreakDown" child-key="CalendarYear" /> -->
<!--
<sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
<sql:relationship name="RevenueBreakdown_RevenueBreakdownDetail"
parent="RevenueBreakdown" parent-key="AccountID BusinessSectionID
CalendarYear" child="RevenueBreakdownDetail" child-key="AccountID
BusinessSectionID CalendarYear" />
-->
</xs:appinfo>
</xs:annotation>
<xs:element name="MicrosoftPartnerProfile"
sql:relation="MicrosoftPartnerProfile">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
<xs:element name="CertificationTierLevelID"
sql:field="CertificationTierLevelID" sql:datatype="varchar" />
<xs:element name="CompanyName" sql:field="CompanyName"
sql:datatype="varchar" />
<xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
sql:datatype="varchar" />
<xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
sql:datatype="int" />
<xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
<xs:element name="District" sql:field="District" sql:datatype="varchar" />
<xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
<xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
sql:datatype="int" />
<xs:element name="NumberOfSalesProfessionals"
sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
<xs:element name="NumberOfEmployeesPerUPP"
sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
<xs:element name="NumberOfTechProfessionals"
sql:field="NumberOfTechProfessionals" sql:datatype="int" />
<xs:element name="OrgHQLocationIndicator"
sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
<xs:element name="NumberOfSalesProfessionalsPerUPP"
sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
<xs:element name="GlobalPartner" sql:field="GlobalPartner"
sql:datatype="varchar" />
<xs:element name="ActiveFlag" sql:field="ActiveFlag"
sql:datatype="varchar" />
<xs:element name="NumberOfTechProfessionalsPerUPP"
sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
<xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
sql:datatype="int" />
<xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
sql:datatype="decimal" />
<xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
sql:datatype="decimal" />
<xs:element name="Seg_1000_14999_Percent"
sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
<xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
sql:datatype="decimal" />
<xs:element name="AddressLine1" sql:field="AddressLine1"
sql:datatype="varchar" />
<xs:element name="AddressLine2" sql:field="AddressLine2"
sql:datatype="varchar" />
<xs:element name="City" sql:field="City" sql:datatype="varchar" />
<xs:element name="PostalCode" sql:field="PostalCode"
sql:datatype="varchar" />
<xs:element name="StateProvinceId" sql:field="StateProvinceId"
sql:datatype="varchar" />
<xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
<xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
<xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar" />
<xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
sql:datatype="datetime" />
<xs:element name="ManagedBy" sql:field="ManagedBy"
sql:datatype="varchar" />
<xs:element name="ParentAccountID" sql:field="ParentAccountID"
sql:datatype="int" />
<xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
<xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
sql:datatype="varchar" />
<xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
sql:datatype="datetime" />
<xs:element name="ParentUPPId" sql:field="ParentUPPId"
sql:datatype="int" />
<xs:element name="CustomCampaign" sql:field="CustomCampaign"
sql:datatype="varchar" />
<xs:element name="PartnerSalesVertical"
sql:relation="PartnerSalesVertical"
sql:relationship=" MicrosoftPartnerProfile_PartnerSalesVert
ical"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerIndustryVertical"
sql:relation="PartnerIndustryVertical"
sql:relationship=" MicrosoftPartnerProfile_PartnerIndustryV
ertical"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerGTM" sql:relation="PartnerGTM"
sql:relationship="MicrosoftPartnerProfile_PartnerGTM" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="GTMFocusID" sql:field="GTMFocusID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
sql:relationship=" MicrosoftPartnerProfile_PartnerCompetenc
y"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CompetencyID" sql:field="CompetencyID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="FormUI" sql:relation="FormUI"
sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CompetencyCheckMode"
sql:field="CompetencyCheckMode" sql:datatype="varchar" />
<xs:element name="SpecializationCheckModel"
sql:field="SpecializationCheckModel" sql:datatype="varchar" />
<xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
sql:datatype="varchar" />
<xs:element name="IndustryVerticalsCheckMode"
sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
<xs:element name="MBSVerticalsCheckMode"
sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
<xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
sql:datatype="varchar" />
<xs:element name="AssessmentsCheckMode"
sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
<xs:element name="AnnualBusinessCurrentMode"
sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
<xs:element name="BusinessPlanCurrentMode"
sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
<xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
sql:datatype="varchar" />
<xs:element name="NavCoreInformation" sql:field="NavCoreInformation"
sql:datatype="varchar" />
<xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
sql:datatype="varchar" />
<xs:element name="NavContact" sql:field="NavContact"
sql:datatype="varchar" />
<xs:element name="NavBranch" sql:field="NavBranch"
sql:datatype="varchar" />
<xs:element name="NavCompetency" sql:field="NavCompetency"
sql:datatype="varchar" />
<xs:element name="NavSpecialization" sql:field="NavSpecialization"
sql:datatype="varchar" />
<xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
sql:datatype="varchar" />
<xs:element name="NavMBSVert" sql:field="NavMBSVert"
sql:datatype="varchar" />
<xs:element name="NavRevSummary" sql:field="NavRevSummary"
sql:datatype="varchar" />
<xs:element name="NavConditions" sql:field="NavConditions"
sql:datatype="varchar" />
<xs:element name="NavRhythm" sql:field="NavRhythm"
sql:datatype="varchar" />
<xs:element name="NavCampaigns" sql:field="NavCampaigns"
sql:datatype="varchar" />
<xs:element name="NavAssessments" sql:field="NavAssessments"
sql:datatype="varchar" />
<xs:element name="NavLinks" sql:field="NavLinks"
sql:datatype="varchar" />
<xs:element name="NavProducts" sql:field="NavProducts"
sql:datatype="varchar" />
<xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
sql:datatype="varchar" />
<xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
sql:datatype="varchar" />
<xs:element name="NavInvestments" sql:field="NavInvestments"
sql:datatype="varchar" />
<xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LinksToOtherDocuments"
sql:relation="LinksToOtherDocuments"
sql:relationship=" MicrosoftPartnerProfile_LinksToOtherDocu
ments">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="DocumentUrl" sql:field="DocumentUrl"
sql:datatype="varchar" />
<xs:element name="DocumentTitle" sql:field="DocumentTitle"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="NotesAndConditions" sql:relation="NotesAndConditions"
sql:relationship=" MicrosoftPartnerProfile_NotesAndConditio
ns">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"
sql:datatype="int" />
<xs:element name="ConditionsOfSatisfaction"
sql:field="ConditionsOfSatisfaction" sql:datatype="varchar" />
<xs:element name="Notes" sql:field="Notes" sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerAssessment" sql:relation="PartnerAssessment"
sql:relationship=" MicrosoftPartnerProfile_PartnerAssessmen
t">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="AssessmentTypeID" sql:field="AssessmentTypeID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnnualBusinessModel"
sql:relation="AnnualBusinessModel"
sql:relationship=" MicrosoftPartnerProfile_AnnualBusinessMo
del">
<xs:complexType>
<xs:sequence>
<xs:element name="PartnerFiscalYearEndDate"
sql:field="PartnerFiscalYearEndDate" sql:datatype="datetime" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="AnnualRevenueInMillions"
sql:field="AnnualRevenueInMillions" sql:datatype="decimal" />
<xs:element name="RevenueGrowthPercentYOY"
sql:field="RevenueGrowthPercentYOY" sql:datatype="decimal" />
<xs:element name="AnnualRevenuePerUPP"
sql:field="AnnualRevenuePerUPP" sql:datatype="decimal" />
<xs:element name="AnnualMSRevenueInMillions"
sql:field="AnnualMSRevenueInMillions" sql:datatype="decimal" />
<xs:element name="AnnualSoftMSRevenuePerUPP"
sql:field="AnnualSoftMSRevenuePerUPP" sql:datatype="decimal" />
<xs:element name="MSRevenueGrowthPercentYOY"
sql:field="MSRevenueGrowthPercentYOY" sql:datatype="decimal" />
<xs:element name="PercentCRM" sql:field="PercentCRM"
sql:datatype="decimal" />
<xs:element name="PercentERP" sql:field="PercentERP"
sql:datatype="decimal" />
<xs:element name="HighlightedProductSubcategoryID"
sql:field="HighlightedProductSubcategoryID" sql:datatype="int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="BusinessFocus" sql:relation="BusinessFocus"
sql:relationship="MicrosoftPartnerProfile_BusinessFocus">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BluePrintQuadrantID"
sql:field="BluePrintQuadrantID" sql:datatype="int" />
<xs:element name="PartnerTypeID" sql:field="PartnerTypeID"
sql:datatype="varchar" />
<xs:element name="DistrictPref1" sql:field="DistrictPref1"
sql:datatype="int" />
<xs:element name="DistrictPref2" sql:field="DistrictPref2"
sql:datatype="int" />
<xs:element name="DistrictPref3" sql:field="DistrictPref3"
sql:datatype="int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerSpecialization"
sql:relation="PartnerSpecialization"
sql:relationship=" MicrosoftPartnerProfile_PartnerSpecializ
ation">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="SpecializationID" sql:field="SpecializationID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ProductMetricsBreakDown"
sql:relation="ProductMetricsBreakDown"
sql:relationship=" AnnualBusinessModel_ProductMetricsBreakD
own" >
<xs:complexType>
<xs:sequence>
<xs:element name="MetricId" sql:field="MetricId" sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="ProductSubCategoryID"
sql:field="ProductSubCategoryID" sql:datatype="int" />
<xs:element name="MetricName" sql:field="MetricName"
sql:datatype="varchar" />
<xs:element name="ProductSubcategoryName"
sql:field="ProductSubcategoryName" sql:datatype="varchar" />
<xs:element name="Half1MSGoal" sql:field="Half1MSGoal"
sql:datatype="decimal" />
<xs:element name="Half1NonMSGoal" sql:field="Half1NonMSGoal"
sql:datatype="decimal" />
<xs:element name="Half1MSActual" sql:field="Half1MSActual"
sql:datatype="decimal" />
<xs:element name="Half1NonMSActual" sql:field="Half1NonMSActual"
sql:datatype="decimal" />
<xs:element name="Half2MSGoal" sql:field="Half2MSGoal"
sql:datatype="decimal" />
<xs:element name="Half2NonMSGoal" sql:field="Half2NonMSGoal"
sql:datatype="decimal" />
<xs:element name="Half2MSActual" sql:field="Half2MSActual"
sql:datatype="decimal" />
<xs:element name="Half2NonMSActual" sql:field="Half2NonMSActual"
sql:datatype="decimal" />
<xs:element name="Total" sql:field="Total" sql:datatype="decimal" />
<xs:element name="TotalPercentage" sql:field="TotalPercentage"
sql:datatype="decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Branch" sql:relation="Branch"
sql:relationship="MicrosoftPartnerProfile_Branch">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BranchAccountID" sql:field="BranchAccountID"
sql:datatype="nvarchar" />
<xs:element name="ExecuteOnLocalMarketingCampaigns"
sql:field="ExecuteOnLocalMarketingCampaigns" sql:datatype="varchar" />
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="BusinessSectionID1" sql:field="BusinessSectionID1"
sql:datatype="int" />
<xs:element name="BusinessSectionID2" sql:field="BusinessSectionID2"
sql:datatype="int" />
<xs:element name="EngagementTypeID" sql:field="EngagementTypeID"
sql:datatype="int" />
<xs:element name="EngagementTypeID1" sql:field="EngagementTypeID1"
sql:datatype="int" />
<xs:element name="EngagementTypeID2" sql:field="EngagementTypeID2"
sql:datatype="int" />
<xs:element name="ExecuteOnMSOpportunityForecasting"
sql:field="ExecuteOnMSOpportunityForecasting" sql:datatype="varchar" />
<xs:element name="AddressLine1" sql:field="AddressLine1"
sql:datatype="varchar" />
<xs:element name="SubDistrictID" sql:field="SubDistrictID"
sql:datatype="int" />
<xs:element name="City" sql:field="City" sql:datatype="varchar" />
<xs:element name="StateProvinceID" sql:field="StateProvinceID"
sql:datatype="varchar" />
<xs:element name="PostalCode" sql:field="PostalCode"
sql:datatype="varchar" />
<xs:element name="NumberOfLocalSalesProfessionals"
sql:field="NumberOfLocalSalesProfessionals" sql:datatype="int" />
<xs:element name="NumberOfLocalTechProfessionals"
sql:field="NumberOfLocalTechProfessionals" sql:datatype="int" />
<xs:element name="BranchName" sql:field="BranchName"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--
<xs:element name="RevenueBreakdown" sql:relation="RevenueBreakdown">
<xs:complexType>
<xs:sequence>
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="PercentMS" sql:field="PercentMS"
sql:datatype="decimal" />
<xs:element name="PercentNonMS" sql:field="PercentNonMS"
sql:datatype="decimal" />
<xs:element name="PercentOfTotal" sql:field="PercentOfTotal"
sql:datatype="decimal" />
<xs:element name="ChildrenVisible" sql:field="ChildrenVisible"
sql:datatype="varchar" />
<xs:element name="RevenueBreakdownDetail"
sql:relation="RevenueBreakdownDetail"
sql:relationship="RevenueBreakdown_RevenueBreakdownDetail"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="BusinessSubsectionID"
sql:field="BusinessSubsectionID" sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="PercentMS" sql:field="PercentMS"
sql:datatype="decimal" />
<xs:element name="PercentNonMS" sql:field="PercentNonMS"
sql:datatype="decimal" />
<xs:element name="PercentOfTotal" sql:field="PercentOfTotal"
sql:datatype="decimal" />
<xs:element name="ChildrenVisible" sql:field="ChildrenVisible"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
-->
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>I resolved the problem. Since this productmetrics table was a child of the
annualbusinessmodel table, it had to be nested in the schema.
:>
"jb" wrote:
> When I try to select with sqlxml I recevie the following error related to
one
> relationship that has a composite key (all none composite key relationship
s
> work).
> Schema: the parent/child table of the relationship on
> 'ProductMetricsBreakDown' does not match.
> The xsd is included that is causing the error is included
> It is the AnnualBusinessModel_ProductMetricsBreakD
own that is giving me th
e
> error.
> Any help would be greatly appreciated.
> <?xml version="1.0" encoding="utf-8"?>
> <xs:schema elementFormDefault="qualified"
> xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
> <xs:annotation>
> <xs:appinfo>
> <sql:relationship name=" MicrosoftPartnerProfile_AnnualBusinessMo
del"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="AnnualBusinessModel" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Branch"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFoc
us"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_FormUI"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
> child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_LinksToOtherDocu
ments"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="LinksToOtherDocuments" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_NotesAndConditio
ns"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="NotesAndConditions" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerAssessmen
t"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerAssessment" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerCompetenc
y"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerCompetency" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
> child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerIndustryV
ertical
"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerIndustryVertical" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerSalesVert
ical"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSalesVertical" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_PartnerSpecializ
ation"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSpecialization" child-key="AccountID" />
> <sql:relationship name=" MicrosoftPartnerProfile_RevenueBreakdown
"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="RevenueBreakdown" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Contact"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
> child-key="AccountID" />
> <sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> <!--<sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own
"
> parent="AnnualBusinessModel" parent-key="CalendarYear"
> child="ProductMetricsBreakDown" child-key="CalendarYear" /> -->
> <!--
> <sql:relationship name=" AnnualBusinessModel_ProductMetricsBreakD
own"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> <sql:relationship name="RevenueBreakdown_RevenueBreakdownDetail"
> parent="RevenueBreakdown" parent-key="AccountID BusinessSectionID
> CalendarYear" child="RevenueBreakdownDetail" child-key="AccountID
> BusinessSectionID CalendarYear" />
> -->
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="MicrosoftPartnerProfile"
> sql:relation="MicrosoftPartnerProfile">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
> <xs:element name="CertificationTierLevelID"
> sql:field="CertificationTierLevelID" sql:datatype="varchar" />
> <xs:element name="CompanyName" sql:field="CompanyName"
> sql:datatype="varchar" />
> <xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
> sql:datatype="varchar" />
> <xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
> sql:datatype="int" />
> <xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
> <xs:element name="District" sql:field="District" sql:datatype="varchar
" />
> <xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
> <xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
> sql:datatype="int" />
> <xs:element name="NumberOfSalesProfessionals"
> sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
> <xs:element name="NumberOfEmployeesPerUPP"
> sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionals"
> sql:field="NumberOfTechProfessionals" sql:datatype="int" />
> <xs:element name="OrgHQLocationIndicator"
> sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
> <xs:element name="NumberOfSalesProfessionalsPerUPP"
> sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="GlobalPartner" sql:field="GlobalPartner"
> sql:datatype="varchar" />
> <xs:element name="ActiveFlag" sql:field="ActiveFlag"
> sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionalsPerUPP"
> sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
> sql:datatype="int" />
> <xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_1000_14999_Percent"
> sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
> <xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
> sql:datatype="decimal" />
> <xs:element name="AddressLine1" sql:field="AddressLine1"
> sql:datatype="varchar" />
> <xs:element name="AddressLine2" sql:field="AddressLine2"
> sql:datatype="varchar" />
> <xs:element name="City" sql:field="City" sql:datatype="varchar" />
> <xs:element name="PostalCode" sql:field="PostalCode"
> sql:datatype="varchar" />
> <xs:element name="StateProvinceId" sql:field="StateProvinceId"
> sql:datatype="varchar" />
> <xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
> <xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
> <xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar
" />
> <xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
> sql:datatype="datetime" />
> <xs:element name="ManagedBy" sql:field="ManagedBy"
> sql:datatype="varchar" />
> <xs:element name="ParentAccountID" sql:field="ParentAccountID"
> sql:datatype="int" />
> <xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
> <xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
> sql:datatype="varchar" />
> <xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
> sql:datatype="datetime" />
> <xs:element name="ParentUPPId" sql:field="ParentUPPId"
> sql:datatype="int" />
> <xs:element name="CustomCampaign" sql:field="CustomCampaign"
> sql:datatype="varchar" />
> <xs:element name="PartnerSalesVertical"
> sql:relation="PartnerSalesVertical"
> sql:relationship=" MicrosoftPartnerProfile_PartnerSalesVert
ical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varcha
r"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerIndustryVertical"
> sql:relation="PartnerIndustryVertical"
> sql:relationship=" MicrosoftPartnerProfile_PartnerIndustryV
ertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID
"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varcha
r"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerGTM" sql:relation="PartnerGTM"
> sql:relationship="MicrosoftPartnerProfile_PartnerGTM" maxOccurs="unbounded
">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="GTMFocusID" sql:field="GTMFocusID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varcha
r"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
> sql:relationship=" MicrosoftPartnerProfile_PartnerCompetenc
y"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyID" sql:field="CompetencyID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varcha
r"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="FormUI" sql:relation="FormUI"
> sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyCheckMode"
> sql:field="CompetencyCheckMode" sql:datatype="varchar" />
> <xs:element name="SpecializationCheckModel"
> sql:field="SpecializationCheckModel" sql:datatype="varchar" />
> <xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
> sql:datatype="varchar" />
> <xs:element name="IndustryVerticalsCheckMode"
> sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="MBSVerticalsCheckMode"
> sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
> sql:datatype="varchar" />
> <xs:element name="AssessmentsCheckMode"
> sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
> <xs:element name="AnnualBusinessCurrentMode"
> sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
> <xs:element name="BusinessPlanCurrentMode"
> sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
> <xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
> sql:datatype="varchar" />
> <xs:element name="NavCoreInformation" sql:field="NavCoreInformation
"
> sql:datatype="varchar" />
> <xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
> sql:datatype="varchar" />
> <xs:element name="NavContact" sql:field="NavContact"
> sql:datatype="varchar" />
> <xs:element name="NavBranch" sql:field="NavBranch"
> sql:datatype="varchar" />
> <xs:element name="NavCompetency" sql:field="NavCompetency"
> sql:datatype="varchar" />
> <xs:element name="NavSpecialization" sql:field="NavSpecialization"
> sql:datatype="varchar" />
> <xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
> sql:datatype="varchar" />
> <xs:element name="NavMBSVert" sql:field="NavMBSVert"
> sql:datatype="varchar" />
> <xs:element name="NavRevSummary" sql:field="NavRevSummary"
> sql:datatype="varchar" />
> <xs:element name="NavConditions" sql:field="NavConditions"
> sql:datatype="varchar" />
> <xs:element name="NavRhythm" sql:field="NavRhythm"
> sql:datatype="varchar" />
> <xs:element name="NavCampaigns" sql:field="NavCampaigns"
> sql:datatype="varchar" />
> <xs:element name="NavAssessments" sql:field="NavAssessments"
> sql:datatype="varchar" />
> <xs:element name="NavLinks" sql:field="NavLinks"
> sql:datatype="varchar" />
> <xs:element name="NavProducts" sql:field="NavProducts"
> sql:datatype="varchar" />
> <xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
> sql:datatype="varchar" />
> <xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
> sql:datatype="varchar" />
> <xs:element name="NavInvestments" sql:field="NavInvestments"
> sql:datatype="varchar" />
> <xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="LinksToOtherDocuments"
> sql:relation="LinksToOtherDocuments"
> sql:relationship=" MicrosoftPartnerProfile_LinksToOtherDocu
ments">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="DocumentUrl" sql:field="DocumentUrl"
> sql:datatype="varchar" />
> <xs:element name="DocumentTitle" sql:field="DocumentTitle"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="NotesAndConditions" sql:relation="NotesAndConditions
"
> sql:relationship=" MicrosoftPartnerProfile_NotesAndConditio
ns">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"[/color
]

parent/child table error in sqlxml

When I try to select with sqlxml I recevie the following error related to one
relationship that has a composite key (all none composite key relationships
work).
Schema: the parent/child table of the relationship on
'ProductMetricsBreakDown' does not match.
The xsd is included that is causing the error is included
It is the AnnualBusinessModel_ProductMetricsBreakDown that is giving me the
error.
Any help would be greatly appreciated.
<?xml version="1.0" encoding="utf-8"?>
<xs:schema elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xs:annotation>
<xs:appinfo>
<sql:relationship name="MicrosoftPartnerProfile_AnnualBusinessModel"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="AnnualBusinessModel" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_Branch"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFocus"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_FormUI"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_LinksToOtherDocument s"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="LinksToOtherDocuments" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_NotesAndConditions"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="NotesAndConditions" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerAssessment"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerAssessment" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerCompetency"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerCompetency" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerIndustryVerti cal"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerIndustryVertical" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerSalesVertical "
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerSalesVertical" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_PartnerSpecializatio n"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="PartnerSpecialization" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_RevenueBreakdown"
parent="MicrosoftPartnerProfile" parent-key="AccountID"
child="RevenueBreakdown" child-key="AccountID" />
<sql:relationship name="MicrosoftPartnerProfile_Contact"
parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
child-key="AccountID" />
<sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
<!--<sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
parent="AnnualBusinessModel" parent-key="CalendarYear"
child="ProductMetricsBreakDown" child-key="CalendarYear" /> -->
<!--
<sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
<sql:relationship name="RevenueBreakdown_RevenueBreakdownDetail"
parent="RevenueBreakdown" parent-key="AccountID BusinessSectionID
CalendarYear" child="RevenueBreakdownDetail" child-key="AccountID
BusinessSectionID CalendarYear" />
-->
</xs:appinfo>
</xs:annotation>
<xs:element name="MicrosoftPartnerProfile"
sql:relation="MicrosoftPartnerProfile">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
<xs:element name="CertificationTierLevelID"
sql:field="CertificationTierLevelID" sql:datatype="varchar" />
<xs:element name="CompanyName" sql:field="CompanyName"
sql:datatype="varchar" />
<xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
sql:datatype="varchar" />
<xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
sql:datatype="int" />
<xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
<xs:element name="District" sql:field="District" sql:datatype="varchar" />
<xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
<xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
sql:datatype="int" />
<xs:element name="NumberOfSalesProfessionals"
sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
<xs:element name="NumberOfEmployeesPerUPP"
sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
<xs:element name="NumberOfTechProfessionals"
sql:field="NumberOfTechProfessionals" sql:datatype="int" />
<xs:element name="OrgHQLocationIndicator"
sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
<xs:element name="NumberOfSalesProfessionalsPerUPP"
sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
<xs:element name="GlobalPartner" sql:field="GlobalPartner"
sql:datatype="varchar" />
<xs:element name="ActiveFlag" sql:field="ActiveFlag"
sql:datatype="varchar" />
<xs:element name="NumberOfTechProfessionalsPerUPP"
sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
<xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
sql:datatype="int" />
<xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
sql:datatype="decimal" />
<xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
sql:datatype="decimal" />
<xs:element name="Seg_1000_14999_Percent"
sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
<xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
sql:datatype="decimal" />
<xs:element name="AddressLine1" sql:field="AddressLine1"
sql:datatype="varchar" />
<xs:element name="AddressLine2" sql:field="AddressLine2"
sql:datatype="varchar" />
<xs:element name="City" sql:field="City" sql:datatype="varchar" />
<xs:element name="PostalCode" sql:field="PostalCode"
sql:datatype="varchar" />
<xs:element name="StateProvinceId" sql:field="StateProvinceId"
sql:datatype="varchar" />
<xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
<xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
<xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar" />
<xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
sql:datatype="datetime" />
<xs:element name="ManagedBy" sql:field="ManagedBy"
sql:datatype="varchar" />
<xs:element name="ParentAccountID" sql:field="ParentAccountID"
sql:datatype="int" />
<xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
<xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
sql:datatype="varchar" />
<xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
sql:datatype="datetime" />
<xs:element name="ParentUPPId" sql:field="ParentUPPId"
sql:datatype="int" />
<xs:element name="CustomCampaign" sql:field="CustomCampaign"
sql:datatype="varchar" />
<xs:element name="PartnerSalesVertical"
sql:relation="PartnerSalesVertical"
sql:relationship="MicrosoftPartnerProfile_PartnerS alesVertical"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerIndustryVertical"
sql:relation="PartnerIndustryVertical"
sql:relationship="MicrosoftPartnerProfile_PartnerI ndustryVertical"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerGTM" sql:relation="PartnerGTM"
sql:relationship="MicrosoftPartnerProfile_PartnerG TM" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="GTMFocusID" sql:field="GTMFocusID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
sql:relationship="MicrosoftPartnerProfile_PartnerC ompetency"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CompetencyID" sql:field="CompetencyID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="FormUI" sql:relation="FormUI"
sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CompetencyCheckMode"
sql:field="CompetencyCheckMode" sql:datatype="varchar" />
<xs:element name="SpecializationCheckModel"
sql:field="SpecializationCheckModel" sql:datatype="varchar" />
<xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
sql:datatype="varchar" />
<xs:element name="IndustryVerticalsCheckMode"
sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
<xs:element name="MBSVerticalsCheckMode"
sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
<xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
sql:datatype="varchar" />
<xs:element name="AssessmentsCheckMode"
sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
<xs:element name="AnnualBusinessCurrentMode"
sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
<xs:element name="BusinessPlanCurrentMode"
sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
<xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
sql:datatype="varchar" />
<xs:element name="NavCoreInformation" sql:field="NavCoreInformation"
sql:datatype="varchar" />
<xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
sql:datatype="varchar" />
<xs:element name="NavContact" sql:field="NavContact"
sql:datatype="varchar" />
<xs:element name="NavBranch" sql:field="NavBranch"
sql:datatype="varchar" />
<xs:element name="NavCompetency" sql:field="NavCompetency"
sql:datatype="varchar" />
<xs:element name="NavSpecialization" sql:field="NavSpecialization"
sql:datatype="varchar" />
<xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
sql:datatype="varchar" />
<xs:element name="NavMBSVert" sql:field="NavMBSVert"
sql:datatype="varchar" />
<xs:element name="NavRevSummary" sql:field="NavRevSummary"
sql:datatype="varchar" />
<xs:element name="NavConditions" sql:field="NavConditions"
sql:datatype="varchar" />
<xs:element name="NavRhythm" sql:field="NavRhythm"
sql:datatype="varchar" />
<xs:element name="NavCampaigns" sql:field="NavCampaigns"
sql:datatype="varchar" />
<xs:element name="NavAssessments" sql:field="NavAssessments"
sql:datatype="varchar" />
<xs:element name="NavLinks" sql:field="NavLinks"
sql:datatype="varchar" />
<xs:element name="NavProducts" sql:field="NavProducts"
sql:datatype="varchar" />
<xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
sql:datatype="varchar" />
<xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
sql:datatype="varchar" />
<xs:element name="NavInvestments" sql:field="NavInvestments"
sql:datatype="varchar" />
<xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="LinksToOtherDocuments"
sql:relation="LinksToOtherDocuments"
sql:relationship="MicrosoftPartnerProfile_LinksToO therDocuments">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="DocumentUrl" sql:field="DocumentUrl"
sql:datatype="varchar" />
<xs:element name="DocumentTitle" sql:field="DocumentTitle"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="NotesAndConditions" sql:relation="NotesAndConditions"
sql:relationship="MicrosoftPartnerProfile_NotesAnd Conditions">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"
sql:datatype="int" />
<xs:element name="ConditionsOfSatisfaction"
sql:field="ConditionsOfSatisfaction" sql:datatype="varchar" />
<xs:element name="Notes" sql:field="Notes" sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerAssessment" sql:relation="PartnerAssessment"
sql:relationship="MicrosoftPartnerProfile_PartnerA ssessment">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="AssessmentTypeID" sql:field="AssessmentTypeID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="AnnualBusinessModel"
sql:relation="AnnualBusinessModel"
sql:relationship="MicrosoftPartnerProfile_AnnualBu sinessModel">
<xs:complexType>
<xs:sequence>
<xs:element name="PartnerFiscalYearEndDate"
sql:field="PartnerFiscalYearEndDate" sql:datatype="datetime" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="AnnualRevenueInMillions"
sql:field="AnnualRevenueInMillions" sql:datatype="decimal" />
<xs:element name="RevenueGrowthPercentYOY"
sql:field="RevenueGrowthPercentYOY" sql:datatype="decimal" />
<xs:element name="AnnualRevenuePerUPP"
sql:field="AnnualRevenuePerUPP" sql:datatype="decimal" />
<xs:element name="AnnualMSRevenueInMillions"
sql:field="AnnualMSRevenueInMillions" sql:datatype="decimal" />
<xs:element name="AnnualSoftMSRevenuePerUPP"
sql:field="AnnualSoftMSRevenuePerUPP" sql:datatype="decimal" />
<xs:element name="MSRevenueGrowthPercentYOY"
sql:field="MSRevenueGrowthPercentYOY" sql:datatype="decimal" />
<xs:element name="PercentCRM" sql:field="PercentCRM"
sql:datatype="decimal" />
<xs:element name="PercentERP" sql:field="PercentERP"
sql:datatype="decimal" />
<xs:element name="HighlightedProductSubcategoryID"
sql:field="HighlightedProductSubcategoryID" sql:datatype="int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="BusinessFocus" sql:relation="BusinessFocus"
sql:relationship="MicrosoftPartnerProfile_Business Focus">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BluePrintQuadrantID"
sql:field="BluePrintQuadrantID" sql:datatype="int" />
<xs:element name="PartnerTypeID" sql:field="PartnerTypeID"
sql:datatype="varchar" />
<xs:element name="DistrictPref1" sql:field="DistrictPref1"
sql:datatype="int" />
<xs:element name="DistrictPref2" sql:field="DistrictPref2"
sql:datatype="int" />
<xs:element name="DistrictPref3" sql:field="DistrictPref3"
sql:datatype="int" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PartnerSpecialization"
sql:relation="PartnerSpecialization"
sql:relationship="MicrosoftPartnerProfile_PartnerS pecialization">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="SpecializationID" sql:field="SpecializationID"
sql:datatype="int" />
<xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ProductMetricsBreakDown"
sql:relation="ProductMetricsBreakDown"
sql:relationship="AnnualBusinessModel_ProductMetri csBreakDown" >
<xs:complexType>
<xs:sequence>
<xs:element name="MetricId" sql:field="MetricId" sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="ProductSubCategoryID"
sql:field="ProductSubCategoryID" sql:datatype="int" />
<xs:element name="MetricName" sql:field="MetricName"
sql:datatype="varchar" />
<xs:element name="ProductSubcategoryName"
sql:field="ProductSubcategoryName" sql:datatype="varchar" />
<xs:element name="Half1MSGoal" sql:field="Half1MSGoal"
sql:datatype="decimal" />
<xs:element name="Half1NonMSGoal" sql:field="Half1NonMSGoal"
sql:datatype="decimal" />
<xs:element name="Half1MSActual" sql:field="Half1MSActual"
sql:datatype="decimal" />
<xs:element name="Half1NonMSActual" sql:field="Half1NonMSActual"
sql:datatype="decimal" />
<xs:element name="Half2MSGoal" sql:field="Half2MSGoal"
sql:datatype="decimal" />
<xs:element name="Half2NonMSGoal" sql:field="Half2NonMSGoal"
sql:datatype="decimal" />
<xs:element name="Half2MSActual" sql:field="Half2MSActual"
sql:datatype="decimal" />
<xs:element name="Half2NonMSActual" sql:field="Half2NonMSActual"
sql:datatype="decimal" />
<xs:element name="Total" sql:field="Total" sql:datatype="decimal" />
<xs:element name="TotalPercentage" sql:field="TotalPercentage"
sql:datatype="decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Branch" sql:relation="Branch"
sql:relationship="MicrosoftPartnerProfile_Branch">
<xs:complexType>
<xs:sequence>
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BranchAccountID" sql:field="BranchAccountID"
sql:datatype="nvarchar" />
<xs:element name="ExecuteOnLocalMarketingCampaigns"
sql:field="ExecuteOnLocalMarketingCampaigns" sql:datatype="varchar" />
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="BusinessSectionID1" sql:field="BusinessSectionID1"
sql:datatype="int" />
<xs:element name="BusinessSectionID2" sql:field="BusinessSectionID2"
sql:datatype="int" />
<xs:element name="EngagementTypeID" sql:field="EngagementTypeID"
sql:datatype="int" />
<xs:element name="EngagementTypeID1" sql:field="EngagementTypeID1"
sql:datatype="int" />
<xs:element name="EngagementTypeID2" sql:field="EngagementTypeID2"
sql:datatype="int" />
<xs:element name="ExecuteOnMSOpportunityForecasting"
sql:field="ExecuteOnMSOpportunityForecasting" sql:datatype="varchar" />
<xs:element name="AddressLine1" sql:field="AddressLine1"
sql:datatype="varchar" />
<xs:element name="SubDistrictID" sql:field="SubDistrictID"
sql:datatype="int" />
<xs:element name="City" sql:field="City" sql:datatype="varchar" />
<xs:element name="StateProvinceID" sql:field="StateProvinceID"
sql:datatype="varchar" />
<xs:element name="PostalCode" sql:field="PostalCode"
sql:datatype="varchar" />
<xs:element name="NumberOfLocalSalesProfessionals"
sql:field="NumberOfLocalSalesProfessionals" sql:datatype="int" />
<xs:element name="NumberOfLocalTechProfessionals"
sql:field="NumberOfLocalTechProfessionals" sql:datatype="int" />
<xs:element name="BranchName" sql:field="BranchName"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
<!--
<xs:element name="RevenueBreakdown" sql:relation="RevenueBreakdown">
<xs:complexType>
<xs:sequence>
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="PercentMS" sql:field="PercentMS"
sql:datatype="decimal" />
<xs:element name="PercentNonMS" sql:field="PercentNonMS"
sql:datatype="decimal" />
<xs:element name="PercentOfTotal" sql:field="PercentOfTotal"
sql:datatype="decimal" />
<xs:element name="ChildrenVisible" sql:field="ChildrenVisible"
sql:datatype="varchar" />
<xs:element name="RevenueBreakdownDetail"
sql:relation="RevenueBreakdownDetail"
sql:relationship="RevenueBreakdown_RevenueBreakdow nDetail"
maxOccurs="unbounded">
<xs:complexType>
<xs:sequence>
<xs:element name="BusinessSubsectionID"
sql:field="BusinessSubsectionID" sql:datatype="int" />
<xs:element name="AccountID" sql:field="AccountID"
sql:datatype="nvarchar" />
<xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
sql:datatype="int" />
<xs:element name="CalendarYear" sql:field="CalendarYear"
sql:datatype="int" />
<xs:element name="PercentMS" sql:field="PercentMS"
sql:datatype="decimal" />
<xs:element name="PercentNonMS" sql:field="PercentNonMS"
sql:datatype="decimal" />
<xs:element name="PercentOfTotal" sql:field="PercentOfTotal"
sql:datatype="decimal" />
<xs:element name="ChildrenVisible" sql:field="ChildrenVisible"
sql:datatype="varchar" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
-->
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
I resolved the problem. Since this productmetrics table was a child of the
annualbusinessmodel table, it had to be nested in the schema.
:>
"jb" wrote:

> When I try to select with sqlxml I recevie the following error related to one
> relationship that has a composite key (all none composite key relationships
> work).
> Schema: the parent/child table of the relationship on
> 'ProductMetricsBreakDown' does not match.
> The xsd is included that is causing the error is included
> It is the AnnualBusinessModel_ProductMetricsBreakDown that is giving me the
> error.
> Any help would be greatly appreciated.
> <?xml version="1.0" encoding="utf-8"?>
> <xs:schema elementFormDefault="qualified"
> xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
> <xs:annotation>
> <xs:appinfo>
> <sql:relationship name="MicrosoftPartnerProfile_AnnualBusinessModel"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="AnnualBusinessModel" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Branch"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFocus"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_FormUI"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_LinksToOtherDocument s"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="LinksToOtherDocuments" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_NotesAndConditions"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="NotesAndConditions" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerAssessment"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerAssessment" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerCompetency"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerCompetency" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerIndustryVerti cal"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerIndustryVertical" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerSalesVertical "
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSalesVertical" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerSpecializatio n"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSpecialization" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_RevenueBreakdown"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="RevenueBreakdown" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Contact"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
> child-key="AccountID" />
> <sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> <!--<sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
> parent="AnnualBusinessModel" parent-key="CalendarYear"
> child="ProductMetricsBreakDown" child-key="CalendarYear" /> -->
> <!--
> <sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> <sql:relationship name="RevenueBreakdown_RevenueBreakdownDetail"
> parent="RevenueBreakdown" parent-key="AccountID BusinessSectionID
> CalendarYear" child="RevenueBreakdownDetail" child-key="AccountID
> BusinessSectionID CalendarYear" />
> -->
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="MicrosoftPartnerProfile"
> sql:relation="MicrosoftPartnerProfile">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
> <xs:element name="CertificationTierLevelID"
> sql:field="CertificationTierLevelID" sql:datatype="varchar" />
> <xs:element name="CompanyName" sql:field="CompanyName"
> sql:datatype="varchar" />
> <xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
> sql:datatype="varchar" />
> <xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
> sql:datatype="int" />
> <xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
> <xs:element name="District" sql:field="District" sql:datatype="varchar" />
> <xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
> <xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
> sql:datatype="int" />
> <xs:element name="NumberOfSalesProfessionals"
> sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
> <xs:element name="NumberOfEmployeesPerUPP"
> sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionals"
> sql:field="NumberOfTechProfessionals" sql:datatype="int" />
> <xs:element name="OrgHQLocationIndicator"
> sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
> <xs:element name="NumberOfSalesProfessionalsPerUPP"
> sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="GlobalPartner" sql:field="GlobalPartner"
> sql:datatype="varchar" />
> <xs:element name="ActiveFlag" sql:field="ActiveFlag"
> sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionalsPerUPP"
> sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
> sql:datatype="int" />
> <xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_1000_14999_Percent"
> sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
> <xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
> sql:datatype="decimal" />
> <xs:element name="AddressLine1" sql:field="AddressLine1"
> sql:datatype="varchar" />
> <xs:element name="AddressLine2" sql:field="AddressLine2"
> sql:datatype="varchar" />
> <xs:element name="City" sql:field="City" sql:datatype="varchar" />
> <xs:element name="PostalCode" sql:field="PostalCode"
> sql:datatype="varchar" />
> <xs:element name="StateProvinceId" sql:field="StateProvinceId"
> sql:datatype="varchar" />
> <xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
> <xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
> <xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar" />
> <xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
> sql:datatype="datetime" />
> <xs:element name="ManagedBy" sql:field="ManagedBy"
> sql:datatype="varchar" />
> <xs:element name="ParentAccountID" sql:field="ParentAccountID"
> sql:datatype="int" />
> <xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
> <xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
> sql:datatype="varchar" />
> <xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
> sql:datatype="datetime" />
> <xs:element name="ParentUPPId" sql:field="ParentUPPId"
> sql:datatype="int" />
> <xs:element name="CustomCampaign" sql:field="CustomCampaign"
> sql:datatype="varchar" />
> <xs:element name="PartnerSalesVertical"
> sql:relation="PartnerSalesVertical"
> sql:relationship="MicrosoftPartnerProfile_PartnerS alesVertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerIndustryVertical"
> sql:relation="PartnerIndustryVertical"
> sql:relationship="MicrosoftPartnerProfile_PartnerI ndustryVertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerGTM" sql:relation="PartnerGTM"
> sql:relationship="MicrosoftPartnerProfile_PartnerG TM" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="GTMFocusID" sql:field="GTMFocusID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
> sql:relationship="MicrosoftPartnerProfile_PartnerC ompetency"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyID" sql:field="CompetencyID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="FormUI" sql:relation="FormUI"
> sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyCheckMode"
> sql:field="CompetencyCheckMode" sql:datatype="varchar" />
> <xs:element name="SpecializationCheckModel"
> sql:field="SpecializationCheckModel" sql:datatype="varchar" />
> <xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
> sql:datatype="varchar" />
> <xs:element name="IndustryVerticalsCheckMode"
> sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="MBSVerticalsCheckMode"
> sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
> sql:datatype="varchar" />
> <xs:element name="AssessmentsCheckMode"
> sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
> <xs:element name="AnnualBusinessCurrentMode"
> sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
> <xs:element name="BusinessPlanCurrentMode"
> sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
> <xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
> sql:datatype="varchar" />
> <xs:element name="NavCoreInformation" sql:field="NavCoreInformation"
> sql:datatype="varchar" />
> <xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
> sql:datatype="varchar" />
> <xs:element name="NavContact" sql:field="NavContact"
> sql:datatype="varchar" />
> <xs:element name="NavBranch" sql:field="NavBranch"
> sql:datatype="varchar" />
> <xs:element name="NavCompetency" sql:field="NavCompetency"
> sql:datatype="varchar" />
> <xs:element name="NavSpecialization" sql:field="NavSpecialization"
> sql:datatype="varchar" />
> <xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
> sql:datatype="varchar" />
> <xs:element name="NavMBSVert" sql:field="NavMBSVert"
> sql:datatype="varchar" />
> <xs:element name="NavRevSummary" sql:field="NavRevSummary"
> sql:datatype="varchar" />
> <xs:element name="NavConditions" sql:field="NavConditions"
> sql:datatype="varchar" />
> <xs:element name="NavRhythm" sql:field="NavRhythm"
> sql:datatype="varchar" />
> <xs:element name="NavCampaigns" sql:field="NavCampaigns"
> sql:datatype="varchar" />
> <xs:element name="NavAssessments" sql:field="NavAssessments"
> sql:datatype="varchar" />
> <xs:element name="NavLinks" sql:field="NavLinks"
> sql:datatype="varchar" />
> <xs:element name="NavProducts" sql:field="NavProducts"
> sql:datatype="varchar" />
> <xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
> sql:datatype="varchar" />
> <xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
> sql:datatype="varchar" />
> <xs:element name="NavInvestments" sql:field="NavInvestments"
> sql:datatype="varchar" />
> <xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="LinksToOtherDocuments"
> sql:relation="LinksToOtherDocuments"
> sql:relationship="MicrosoftPartnerProfile_LinksToO therDocuments">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="DocumentUrl" sql:field="DocumentUrl"
> sql:datatype="varchar" />
> <xs:element name="DocumentTitle" sql:field="DocumentTitle"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="NotesAndConditions" sql:relation="NotesAndConditions"
> sql:relationship="MicrosoftPartnerProfile_NotesAnd Conditions">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"
|||
> When I try to select with sqlxml I recevie the following error related to one
> relationship that has a composite key (all none composite key relationships
> work).
> Schema: the parent/child table of the relationship on
> 'ProductMetricsBreakDown' does not match.
> The xsd is included that is causing the error is included
> It is the AnnualBusinessModel_ProductMetricsBreakDown that is giving me the
> error.
> Any help would be greatly appreciated.
> <?xml version="1.0" encoding="utf-8"?>
> <xs:schema elementFormDefault="qualified"
> xmlns:xs="http://www.w3.org/2001/XMLSchema"
> xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
> <xs:annotation>
> <xs:appinfo>
> <sql:relationship name="MicrosoftPartnerProfile_AnnualBusinessModel"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="AnnualBusinessModel" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Branch"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Branch"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_BusinessFocus"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="BusinessFocus"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_FormUI"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="FormUI"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_LinksToOtherDocument s"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="LinksToOtherDocuments" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_NotesAndConditions"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="NotesAndConditions" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerAssessment"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerAssessment" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerCompetency"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerCompetency" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerGTM"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="PartnerGTM"
> child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerIndustryVerti cal"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerIndustryVertical" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerSalesVertical "
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSalesVertical" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_PartnerSpecializatio n"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="PartnerSpecialization" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_RevenueBreakdown"
> parent="MicrosoftPartnerProfile" parent-key="AccountID"
> child="RevenueBreakdown" child-key="AccountID" />
> <sql:relationship name="MicrosoftPartnerProfile_Contact"
> parent="MicrosoftPartnerProfile" parent-key="AccountID" child="Contact"
> child-key="AccountID" />
> <sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> <!--<sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
> parent="AnnualBusinessModel" parent-key="CalendarYear"
> child="ProductMetricsBreakDown" child-key="CalendarYear" /> -->
> <!--
> <sql:relationship name="AnnualBusinessModel_ProductMetricsBreakDown"
> parent="AnnualBusinessModel" parent-key="AccountID CalendarYear"
> child="ProductMetricsBreakDown" child-key="AccountID CalendarYear" />
> <sql:relationship name="RevenueBreakdown_RevenueBreakdownDetail"
> parent="RevenueBreakdown" parent-key="AccountID BusinessSectionID
> CalendarYear" child="RevenueBreakdownDetail" child-key="AccountID
> BusinessSectionID CalendarYear" />
> -->
> </xs:appinfo>
> </xs:annotation>
> <xs:element name="MicrosoftPartnerProfile"
> sql:relation="MicrosoftPartnerProfile">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="NativeID" sql:field="NativeID" sql:datatype="int" />
> <xs:element name="CertificationTierLevelID"
> sql:field="CertificationTierLevelID" sql:datatype="varchar" />
> <xs:element name="CompanyName" sql:field="CompanyName"
> sql:datatype="varchar" />
> <xs:element name="DoingBusinessAsName" sql:field="DoingBusinessAsName"
> sql:datatype="varchar" />
> <xs:element name="GeographicAreaID" sql:field="GeographicAreaID"
> sql:datatype="int" />
> <xs:element name="Region" sql:field="Region" sql:datatype="varchar" />
> <xs:element name="District" sql:field="District" sql:datatype="varchar" />
> <xs:element name="MatrixID" sql:field="MatrixID" sql:datatype="int" />
> <xs:element name="NumberOfEmployees" sql:field="NumberOfEmployees"
> sql:datatype="int" />
> <xs:element name="NumberOfSalesProfessionals"
> sql:field="NumberOfSalesProfessionals" sql:datatype="int" />
> <xs:element name="NumberOfEmployeesPerUPP"
> sql:field="NumberOfEmployeesPerUPP" sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionals"
> sql:field="NumberOfTechProfessionals" sql:datatype="int" />
> <xs:element name="OrgHQLocationIndicator"
> sql:field="OrgHQLocationIndicator" sql:datatype="varchar" />
> <xs:element name="NumberOfSalesProfessionalsPerUPP"
> sql:field="NumberOfSalesProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="GlobalPartner" sql:field="GlobalPartner"
> sql:datatype="varchar" />
> <xs:element name="ActiveFlag" sql:field="ActiveFlag"
> sql:datatype="varchar" />
> <xs:element name="NumberOfTechProfessionalsPerUPP"
> sql:field="NumberOfTechProfessionalsPerUPP" sql:datatype="varchar" />
> <xs:element name="MSOrganizationID" sql:field="MSOrganizationID"
> sql:datatype="int" />
> <xs:element name="Seg_1_49_Percent" sql:field="Seg_1_49_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_50_999_Percent" sql:field="Seg_50_999_Percent"
> sql:datatype="decimal" />
> <xs:element name="Seg_1000_14999_Percent"
> sql:field="Seg_1000_14999_Percent" sql:datatype="decimal" />
> <xs:element name="Seg_15000_Percent" sql:field="Seg_15000_Percent"
> sql:datatype="decimal" />
> <xs:element name="AddressLine1" sql:field="AddressLine1"
> sql:datatype="varchar" />
> <xs:element name="AddressLine2" sql:field="AddressLine2"
> sql:datatype="varchar" />
> <xs:element name="City" sql:field="City" sql:datatype="varchar" />
> <xs:element name="PostalCode" sql:field="PostalCode"
> sql:datatype="varchar" />
> <xs:element name="StateProvinceId" sql:field="StateProvinceId"
> sql:datatype="varchar" />
> <xs:element name="Phone" sql:field="Phone" sql:datatype="varchar" />
> <xs:element name="SiebelID" sql:field="SiebelID" sql:datatype="int" />
> <xs:element name="StatusID" sql:field="StatusID" sql:datatype="varchar" />
> <xs:element name="ProfileDueDate" sql:field="ProfileDueDate"
> sql:datatype="datetime" />
> <xs:element name="ManagedBy" sql:field="ManagedBy"
> sql:datatype="varchar" />
> <xs:element name="ParentAccountID" sql:field="ParentAccountID"
> sql:datatype="int" />
> <xs:element name="UPPID" sql:field="UPPID" sql:datatype="int" />
> <xs:element name="LastModifiedBy" sql:field="LastModifiedBy"
> sql:datatype="varchar" />
> <xs:element name="LastModifiedDate" sql:field="LastModifiedDate"
> sql:datatype="datetime" />
> <xs:element name="ParentUPPId" sql:field="ParentUPPId"
> sql:datatype="int" />
> <xs:element name="CustomCampaign" sql:field="CustomCampaign"
> sql:datatype="varchar" />
> <xs:element name="PartnerSalesVertical"
> sql:relation="PartnerSalesVertical"
> sql:relationship="MicrosoftPartnerProfile_PartnerS alesVertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="SalesVerticalID" sql:field="SalesVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerIndustryVertical"
> sql:relation="PartnerIndustryVertical"
> sql:relationship="MicrosoftPartnerProfile_PartnerI ndustryVertical"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="IndustryVerticalID" sql:field="IndustryVerticalID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerGTM" sql:relation="PartnerGTM"
> sql:relationship="MicrosoftPartnerProfile_PartnerG TM" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="GTMFocusID" sql:field="GTMFocusID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerCompetency" sql:relation="PartnerCompetency"
> sql:relationship="MicrosoftPartnerProfile_PartnerC ompetency"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyID" sql:field="CompetencyID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="FormUI" sql:relation="FormUI"
> sql:relationship="MicrosoftPartnerProfile_FormUI" maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CompetencyCheckMode"
> sql:field="CompetencyCheckMode" sql:datatype="varchar" />
> <xs:element name="SpecializationCheckModel"
> sql:field="SpecializationCheckModel" sql:datatype="varchar" />
> <xs:element name="ProductsCheckMode" sql:field="ProductsCheckMode"
> sql:datatype="varchar" />
> <xs:element name="IndustryVerticalsCheckMode"
> sql:field="IndustryVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="MBSVerticalsCheckMode"
> sql:field="MBSVerticalsCheckMode" sql:datatype="varchar" />
> <xs:element name="GTMSCheckMode" sql:field="GTMSCheckMode"
> sql:datatype="varchar" />
> <xs:element name="AssessmentsCheckMode"
> sql:field="AssessmentsCheckMode" sql:datatype="varchar" />
> <xs:element name="AnnualBusinessCurrentMode"
> sql:field="AnnualBusinessCurrentMode" sql:datatype="varchar" />
> <xs:element name="BusinessPlanCurrentMode"
> sql:field="BusinessPlanCurrentMode" sql:datatype="varchar" />
> <xs:element name="NavProfileStatus" sql:field="NavProfileStatus"
> sql:datatype="varchar" />
> <xs:element name="NavCoreInformation" sql:field="NavCoreInformation"
> sql:datatype="varchar" />
> <xs:element name="NavBusinessFocus" sql:field="NavBusinessFocus"
> sql:datatype="varchar" />
> <xs:element name="NavContact" sql:field="NavContact"
> sql:datatype="varchar" />
> <xs:element name="NavBranch" sql:field="NavBranch"
> sql:datatype="varchar" />
> <xs:element name="NavCompetency" sql:field="NavCompetency"
> sql:datatype="varchar" />
> <xs:element name="NavSpecialization" sql:field="NavSpecialization"
> sql:datatype="varchar" />
> <xs:element name="NavIndustryVert" sql:field="NavIndustryVert"
> sql:datatype="varchar" />
> <xs:element name="NavMBSVert" sql:field="NavMBSVert"
> sql:datatype="varchar" />
> <xs:element name="NavRevSummary" sql:field="NavRevSummary"
> sql:datatype="varchar" />
> <xs:element name="NavConditions" sql:field="NavConditions"
> sql:datatype="varchar" />
> <xs:element name="NavRhythm" sql:field="NavRhythm"
> sql:datatype="varchar" />
> <xs:element name="NavCampaigns" sql:field="NavCampaigns"
> sql:datatype="varchar" />
> <xs:element name="NavAssessments" sql:field="NavAssessments"
> sql:datatype="varchar" />
> <xs:element name="NavLinks" sql:field="NavLinks"
> sql:datatype="varchar" />
> <xs:element name="NavProducts" sql:field="NavProducts"
> sql:datatype="varchar" />
> <xs:element name="NavPlanStatus" sql:field="NavPlanStatus"
> sql:datatype="varchar" />
> <xs:element name="NavGoalSummary" sql:field="NavGoalSummary"
> sql:datatype="varchar" />
> <xs:element name="NavInvestments" sql:field="NavInvestments"
> sql:datatype="varchar" />
> <xs:element name="NavSolutionPlan" sql:field="NavSolutionPlan"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="LinksToOtherDocuments"
> sql:relation="LinksToOtherDocuments"
> sql:relationship="MicrosoftPartnerProfile_LinksToO therDocuments">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="DocumentUrl" sql:field="DocumentUrl"
> sql:datatype="varchar" />
> <xs:element name="DocumentTitle" sql:field="DocumentTitle"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="NotesAndConditions" sql:relation="NotesAndConditions"
> sql:relationship="MicrosoftPartnerProfile_NotesAnd Conditions">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="MeetingFrequencyID" sql:field="MeetingFrequencyID"
> sql:datatype="int" />
> <xs:element name="ConditionsOfSatisfaction"
> sql:field="ConditionsOfSatisfaction" sql:datatype="varchar" />
> <xs:element name="Notes" sql:field="Notes" sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerAssessment" sql:relation="PartnerAssessment"
> sql:relationship="MicrosoftPartnerProfile_PartnerA ssessment">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="AssessmentTypeID" sql:field="AssessmentTypeID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="AnnualBusinessModel"
> sql:relation="AnnualBusinessModel"
> sql:relationship="MicrosoftPartnerProfile_AnnualBu sinessModel">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="PartnerFiscalYearEndDate"
> sql:field="PartnerFiscalYearEndDate" sql:datatype="datetime" />
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CalendarYear" sql:field="CalendarYear"
> sql:datatype="int" />
> <xs:element name="AnnualRevenueInMillions"
> sql:field="AnnualRevenueInMillions" sql:datatype="decimal" />
> <xs:element name="RevenueGrowthPercentYOY"
> sql:field="RevenueGrowthPercentYOY" sql:datatype="decimal" />
> <xs:element name="AnnualRevenuePerUPP"
> sql:field="AnnualRevenuePerUPP" sql:datatype="decimal" />
> <xs:element name="AnnualMSRevenueInMillions"
> sql:field="AnnualMSRevenueInMillions" sql:datatype="decimal" />
> <xs:element name="AnnualSoftMSRevenuePerUPP"
> sql:field="AnnualSoftMSRevenuePerUPP" sql:datatype="decimal" />
> <xs:element name="MSRevenueGrowthPercentYOY"
> sql:field="MSRevenueGrowthPercentYOY" sql:datatype="decimal" />
> <xs:element name="PercentCRM" sql:field="PercentCRM"
> sql:datatype="decimal" />
> <xs:element name="PercentERP" sql:field="PercentERP"
> sql:datatype="decimal" />
> <xs:element name="HighlightedProductSubcategoryID"
> sql:field="HighlightedProductSubcategoryID" sql:datatype="int" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="BusinessFocus" sql:relation="BusinessFocus"
> sql:relationship="MicrosoftPartnerProfile_Business Focus">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="BluePrintQuadrantID"
> sql:field="BluePrintQuadrantID" sql:datatype="int" />
> <xs:element name="PartnerTypeID" sql:field="PartnerTypeID"
> sql:datatype="varchar" />
> <xs:element name="DistrictPref1" sql:field="DistrictPref1"
> sql:datatype="int" />
> <xs:element name="DistrictPref2" sql:field="DistrictPref2"
> sql:datatype="int" />
> <xs:element name="DistrictPref3" sql:field="DistrictPref3"
> sql:datatype="int" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="PartnerSpecialization"
> sql:relation="PartnerSpecialization"
> sql:relationship="MicrosoftPartnerProfile_PartnerS pecialization">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="SpecializationID" sql:field="SpecializationID"
> sql:datatype="int" />
> <xs:element name="Checked" sql:field="Checked" sql:datatype="varchar"
> />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="ProductMetricsBreakDown"
> sql:relation="ProductMetricsBreakDown"
> sql:relationship="AnnualBusinessModel_ProductMetri csBreakDown" >
> <xs:complexType>
> <xs:sequence>
> <xs:element name="MetricId" sql:field="MetricId" sql:datatype="int" />
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CalendarYear" sql:field="CalendarYear"
> sql:datatype="int" />
> <xs:element name="ProductSubCategoryID"
> sql:field="ProductSubCategoryID" sql:datatype="int" />
> <xs:element name="MetricName" sql:field="MetricName"
> sql:datatype="varchar" />
> <xs:element name="ProductSubcategoryName"
> sql:field="ProductSubcategoryName" sql:datatype="varchar" />
> <xs:element name="Half1MSGoal" sql:field="Half1MSGoal"
> sql:datatype="decimal" />
> <xs:element name="Half1NonMSGoal" sql:field="Half1NonMSGoal"
> sql:datatype="decimal" />
> <xs:element name="Half1MSActual" sql:field="Half1MSActual"
> sql:datatype="decimal" />
> <xs:element name="Half1NonMSActual" sql:field="Half1NonMSActual"
> sql:datatype="decimal" />
> <xs:element name="Half2MSGoal" sql:field="Half2MSGoal"
> sql:datatype="decimal" />
> <xs:element name="Half2NonMSGoal" sql:field="Half2NonMSGoal"
> sql:datatype="decimal" />
> <xs:element name="Half2MSActual" sql:field="Half2MSActual"
> sql:datatype="decimal" />
> <xs:element name="Half2NonMSActual" sql:field="Half2NonMSActual"
> sql:datatype="decimal" />
> <xs:element name="Total" sql:field="Total" sql:datatype="decimal" />
> <xs:element name="TotalPercentage" sql:field="TotalPercentage"
> sql:datatype="decimal" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <xs:element name="Branch" sql:relation="Branch"
> sql:relationship="MicrosoftPartnerProfile_Branch">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="BranchAccountID" sql:field="BranchAccountID"
> sql:datatype="nvarchar" />
> <xs:element name="ExecuteOnLocalMarketingCampaigns"
> sql:field="ExecuteOnLocalMarketingCampaigns" sql:datatype="varchar" />
> <xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
> sql:datatype="int" />
> <xs:element name="BusinessSectionID1" sql:field="BusinessSectionID1"
> sql:datatype="int" />
> <xs:element name="BusinessSectionID2" sql:field="BusinessSectionID2"
> sql:datatype="int" />
> <xs:element name="EngagementTypeID" sql:field="EngagementTypeID"
> sql:datatype="int" />
> <xs:element name="EngagementTypeID1" sql:field="EngagementTypeID1"
> sql:datatype="int" />
> <xs:element name="EngagementTypeID2" sql:field="EngagementTypeID2"
> sql:datatype="int" />
> <xs:element name="ExecuteOnMSOpportunityForecasting"
> sql:field="ExecuteOnMSOpportunityForecasting" sql:datatype="varchar" />
> <xs:element name="AddressLine1" sql:field="AddressLine1"
> sql:datatype="varchar" />
> <xs:element name="SubDistrictID" sql:field="SubDistrictID"
> sql:datatype="int" />
> <xs:element name="City" sql:field="City" sql:datatype="varchar" />
> <xs:element name="StateProvinceID" sql:field="StateProvinceID"
> sql:datatype="varchar" />
> <xs:element name="PostalCode" sql:field="PostalCode"
> sql:datatype="varchar" />
> <xs:element name="NumberOfLocalSalesProfessionals"
> sql:field="NumberOfLocalSalesProfessionals" sql:datatype="int" />
> <xs:element name="NumberOfLocalTechProfessionals"
> sql:field="NumberOfLocalTechProfessionals" sql:datatype="int" />
> <xs:element name="BranchName" sql:field="BranchName"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> <!--
> <xs:element name="RevenueBreakdown" sql:relation="RevenueBreakdown">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
> sql:datatype="int" />
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="CalendarYear" sql:field="CalendarYear"
> sql:datatype="int" />
> <xs:element name="PercentMS" sql:field="PercentMS"
> sql:datatype="decimal" />
> <xs:element name="PercentNonMS" sql:field="PercentNonMS"
> sql:datatype="decimal" />
> <xs:element name="PercentOfTotal" sql:field="PercentOfTotal"
> sql:datatype="decimal" />
> <xs:element name="ChildrenVisible" sql:field="ChildrenVisible"
> sql:datatype="varchar" />
> <xs:element name="RevenueBreakdownDetail"
> sql:relation="RevenueBreakdownDetail"
> sql:relationship="RevenueBreakdown_RevenueBreakdow nDetail"
> maxOccurs="unbounded">
> <xs:complexType>
> <xs:sequence>
> <xs:element name="BusinessSubsectionID"
> sql:field="BusinessSubsectionID" sql:datatype="int" />
> <xs:element name="AccountID" sql:field="AccountID"
> sql:datatype="nvarchar" />
> <xs:element name="BusinessSectionID" sql:field="BusinessSectionID"
> sql:datatype="int" />
> <xs:element name="CalendarYear" sql:field="CalendarYear"
> sql:datatype="int" />
> <xs:element name="PercentMS" sql:field="PercentMS"
> sql:datatype="decimal" />
> <xs:element name="PercentNonMS" sql:field="PercentNonMS"
> sql:datatype="decimal" />
> <xs:element name="PercentOfTotal" sql:field="PercentOfTotal"
> sql:datatype="decimal" />
> <xs:element name="ChildrenVisible" sql:field="ChildrenVisible"
> sql:datatype="varchar" />
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> -->
> </xs:sequence>
> </xs:complexType>
> </xs:element>
> </xs:schema>
>
>
>
What do you mean, you had to nest it? Where? Under what node?
BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities