Post reply

Creating SSIS Package with XML Source

  • December 28, 2011 at 2:27 pm

    #265464

    Hi,

    I am new to SSIS Package Creation, I have and XML Source which in need to load in SQL Server Table's . In XML File in Header Section i have DocumentIDentifier and DocumentDatetime and in SQL Server Table i have created tables with this Columns. I want these columns to be added in SQL Tables that i have created . Can any body help me.....

    Here is the XML File which i am using....

    <?xml version="1.0" encoding="utf-8"?>

    <Data>

    <AGIISEntityFullExtract xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <Header>

    <ThisDocumentIdentifier>

    <DocumentIdentifier>20090701T0415020001</DocumentIdentifier>

    </ThisDocumentIdentifier>

    <ThisDocumentDateTime>

    <DateTime DateTimeQualifier="On">20090701T041502</DateTime>

    </ThisDocumentDateTime>

    <From>

    <PartnerInformation>

    <PartnerName>Covansys</PartnerName>

    <PartnerIdentifier Agency="EBID">1324108090000</PartnerIdentifier>

    <ContactInformation>

    <ContactName>Lorie Gasso</ContactName>

    <TelephoneNumber>

    <NationalTelephoneNumber>(866)251-8618</NationalTelephoneNumber>

    </TelephoneNumber>

    <EmailAddress>cbrown210@csc.com</EmailAddress>

    </ContactInformation>

    </PartnerInformation>

    </From>

    <To>

    <PartnerInformation>

    <PartnerName>GS1 US INC</PartnerName>

    <PartnerIdentifier Agency="EBID">1132282040000</PartnerIdentifier>

    <ContactInformation>

    <ContactName>Sean Lockhead</ContactName>

    <TelephoneNumber>

    <NationalTelephoneNumber>(609) 620-4645</NationalTelephoneNumber>

    </TelephoneNumber>

    <EmailAddress>cbrown210@csc.com</EmailAddress>

    </ContactInformation>

    </PartnerInformation>

    </To>

    </Header>

    <Body>

    <AGIISEntityFullExtractDetails>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100011442291</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>JAMES OWEN QUINLEY</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>2894 SHELBY 308</AddressLine1>

    <CityName>CLARENCE</CityName>

    <StateOrProvince>MO</StateOrProvince>

    <PostalCode>634373222</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>29205</FIPSCode>

    <CountyName>SHELBY</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043235052</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>COLUMBUS FLOORCOVERING SUPPLIES</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>6351 CATALINA DR</AddressLine1>

    <CityName>COLUMBUS</CityName>

    <StateOrProvince>GA</StateOrProvince>

    <PostalCode>319093628</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>13215</FIPSCode>

    <CountyName>MUSCOGEE</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100042536389</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>FEED STORE LLC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>1029 MONTGOMERY HWY</AddressLine1>

    <CityName>DOTHAN</CityName>

    <StateOrProvince>AL</StateOrProvince>

    <PostalCode>363036057</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>01069</FIPSCode>

    <CountyName>HOUSTON</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043548602</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CENTRAL GEORGIA CO-OP INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>43 HOUSTON ST</AddressLine1>

    <CityName>HAWKINSVILLE</CityName>

    <StateOrProvince>GA</StateOrProvince>

    <PostalCode>310364917</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>13235</FIPSCode>

    <CountyName>PULASKI</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043549456</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>MORGAN CO COMMISSION</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>302 LEE ST NE</AddressLine1>

    <CityName>DECATUR</CityName>

    <StateOrProvince>AL</StateOrProvince>

    <PostalCode>356011926</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>01103</FIPSCode>

    <CountyName>MORGAN</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069004249</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>418 E NORTH ST</AddressLine1>

    <CityName>DWIGHT</CityName>

    <StateOrProvince>IL</StateOrProvince>

    <PostalCode>604201016</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>17105</FIPSCode>

    <CountyName>LIVINGSTON</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043549777</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>KERRVILLE RANCH & PET CENTER</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>516 QUINLAN ST</AddressLine1>

    <CityName>KERRVILLE</CityName>

    <StateOrProvince>TX</StateOrProvince>

    <PostalCode>780284455</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>48265</FIPSCode>

    <CountyName>KERR</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Inactive">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043550667</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>BUNTINGS DUSTING INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>9758 CAREY RD</AddressLine1>

    <CityName>BERLIN</CityName>

    <StateOrProvince>MD</StateOrProvince>

    <PostalCode>218112116</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>24047</FIPSCode>

    <CountyName>WORCESTER</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043551053</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>STEPHENSON MKTG COOPERATIVE INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>1109 COUNTY ROAD B</AddressLine1>

    <CityName>NIAGARA</CityName>

    <StateOrProvince>WI</StateOrProvince>

    <PostalCode>541519198</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>55037</FIPSCode>

    <CountyName>FLORENCE</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100039856452</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>INTERMOUNTAIN FARMERS ASSOCIATION INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>212 S 800 W</AddressLine1>

    <CityName>SALINA</CityName>

    <StateOrProvince>UT</StateOrProvince>

    <PostalCode>846541077</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>49041</FIPSCode>

    <CountyName>SEVIER</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043552043</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>MAUNEY FEED MILL INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>40225 US HIGHWAY 52 N</AddressLine1>

    <CityName>NEW LONDON</CityName>

    <StateOrProvince>NC</StateOrProvince>

    <PostalCode>281278552</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>37167</FIPSCode>

    <CountyName>STANLY</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100037503624</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>FARMERS UNION COOP GIN INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>DELHI COMMUNITY</AddressLine1>

    <CityName>SAYRE</CityName>

    <StateOrProvince>OK</StateOrProvince>

    <PostalCode>73662</PostalCode>

    <FIPSCode>40009</FIPSCode>

    <CountyName>BECKHAM</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043552869</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>PIONEER HI-BRED INTERNATIONAL</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>400 LOCUST ST STE 700</AddressLine1>

    <CityName>DES MOINES</CityName>

    <StateOrProvince>IA</StateOrProvince>

    <PostalCode>503092349</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>19153</FIPSCode>

    <CountyName>POLK</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069005512</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>14150 W CORPORATION DR</AddressLine1>

    <CityName>DEPUTY</CityName>

    <StateOrProvince>IN</StateOrProvince>

    <PostalCode>47230</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>18077</FIPSCode>

    <CountyName>JEFFERSON</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069005475</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>7440 W STATE ROAD 44</AddressLine1>

    <CityName>HOMER</CityName>

    <StateOrProvince>IN</StateOrProvince>

    <PostalCode>461469806</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>18139</FIPSCode>

    <CountyName>RUSH</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069004508</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>12100 WINE HILL RD</AddressLine1>

    <CityName>STEELEVILLE</CityName>

    <StateOrProvince>IL</StateOrProvince>

    <PostalCode>622883006</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>17157</FIPSCode>

    <CountyName>RANDOLPH</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043557024</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>DELTA GROWERS ASSN</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>275 W COUNTY HIGHWAY 450</AddressLine1>

    <CityName>SIKESTON</CityName>

    <StateOrProvince>MO</StateOrProvince>

    <PostalCode>638018474</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>29201</FIPSCode>

    <CountyName>SCOTT</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Inactive">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100011006271</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>BROADWELL FARM CENTER INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>204 N JACOBS ST</AddressLine1>

    <CityName>BROADWELL</CityName>

    <StateOrProvince>IL</StateOrProvince>

    <PostalCode>626346315</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>17107</FIPSCode>

    <CountyName>LOGAN</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043557833</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>HAYWOOD TURF MANAGMENT</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>4886 STARBOARD CT</AddressLine1>

    <CityName>DOUGLASVILLE</CityName>

    <StateOrProvince>GA</StateOrProvince>

    <PostalCode>301351852</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>13097</FIPSCode>

    <CountyName>DOUGLAS</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043558250</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>ARIZONA AG SERVICE INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>25007 S MCQUEEN RD</AddressLine1>

    <CityName>CHANDLER</CityName>

    <StateOrProvince>AZ</StateOrProvince>

    <PostalCode>852493616</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>04013</FIPSCode>

    <CountyName>MARICOPA</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069004614</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>203 S BENNET ST</AddressLine1>

    <CityName>HARVEL</CityName>

    <StateOrProvince>IL</StateOrProvince>

    <PostalCode>62538</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>17135</FIPSCode>

    <CountyName>MONTGOMERY</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100015505459</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>SOUTH DAKOTA WHEAT GROWERS ASSOCIATION</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>200 ELEVATOR AVE</AddressLine1>

    <CityName>BERLIN</CityName>

    <StateOrProvince>ND</StateOrProvince>

    <PostalCode>58415</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>38045</FIPSCode>

    <CountyName>LAMOURE</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069004423</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>25245 HWY 52 S</AddressLine1>

    <CityName>GARNAVILLO</CityName>

    <StateOrProvince>IA</StateOrProvince>

    <PostalCode>52049</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>19043</FIPSCode>

    <CountyName>CLAYTON</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069004454</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>110 1ST ST N</AddressLine1>

    <CityName>WORTHINGTON</CityName>

    <StateOrProvince>IA</StateOrProvince>

    <PostalCode>520789100</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>19061</FIPSCode>

    <CountyName>DUBUQUE</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>1100043560765</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>MID STATE FARMERS COOP</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>HWY 96</AddressLine1>

    <CityName>RUSH CENTER</CityName>

    <StateOrProvince>KS</StateOrProvince>

    <PostalCode>67575</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>20165</FIPSCode>

    <CountyName>RUSH</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069005574</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>112 UNION ST</AddressLine1>

    <CityName>WEST COLLEGE CORNER</CityName>

    <StateOrProvince>IN</StateOrProvince>

    <PostalCode>47003</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>18161</FIPSCode>

    <CountyName>UNION</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069004225</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>601 N COURT ST</AddressLine1>

    <CityName>PONTIAC</CityName>

    <StateOrProvince>IL</StateOrProvince>

    <PostalCode>617641709</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>17105</FIPSCode>

    <CountyName>LIVINGSTON</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    <EntityInformation ActiveFlag="Active">

    <IndustryIdentifier Agency="GLN">

    <IndustryCode>0741069004430</IndustryCode>

    </IndustryIdentifier>

    <PreferredName>CROP PRODUCTION SERVICES INC</PreferredName>

    <PhysicalAddress Overridden="False">

    <AddressLine1>302 E JONES ST</AddressLine1>

    <CityName>WYOMING</CityName>

    <StateOrProvince>IA</StateOrProvince>

    <PostalCode>523627736</PostalCode>

    <PostalCountry>US</PostalCountry>

    <FIPSCode>19105</FIPSCode>

    <CountyName>JONES</CountyName>

    </PhysicalAddress>

    </EntityInformation>

    </AGIISEntityFullExtractDetails>

    </Body></AGIISEntityFullExtract></Data>

    Here are the table which i created.

    Table (1)

    Agencynvarchar(255)

    IndustryCodenumeric(20, 0)

    EntityInformation_Idnumeric(20, 0)

    Batch_IDnvarchar(255)

    Batch_Datenvarchar(50)

    Table 2

    FirstNamenvarchar(255)

    MiddleNamenvarchar(255)

    LastNamenvarchar(255)

    Suffixnvarchar(255)

    EntityInformation_Idnumeric(20, 0)

    Batch_Idnvarchar(255)

    Batch_Datenvarchar(50)

  • December 28, 2011 at 2:58 pm

    #1426269

    [

  • December 28, 2011 at 3:02 pm

    #1426272

    I strongly recommend you immediately remove the obviously real data, unless you have proper authorization from each and every company you've listed!!

    Replace the data with obfuscated values.

    Edit: to post it twice only makes it worse...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 28, 2011 at 3:13 pm

    #1426275

    http://blog.hoegaerden.be/2011/04/07/loading-xml-using-ssis/

    I recomend this to you and follow step by step as explained and it is that easy.

    Looks like there is an error processing the xml at this line

    <PreferredName>KERRVILLE RANCH & PET CENTER</PreferredName>

    While I playing I removed the "&" sign in the above line and worked on it.

    Work on how to load your data from XML and after that research if this "&" is a data issue.

    Hope this helps you out!!

    I guess you will make it out easily.

  • October 12, 2012 at 2:18 am

    #1548482

    I followed the example in the blog http://blog.hoegaerden.be/2011/04/07/loading-xml-using-ssis/

    but no matter what I try the output only lists the values in the first column and will not display any of the second column values.

    here is the xml :

    <colors>

    <color RGB="FF0000">Red</color>

    <color RGB="00FF00">Green</color>

    <color RGB="0000FF">Blue</color>

    <color RGB="FFFFFF">White</color>

    <color RGB="000000">Black</color>

    </colors>

    this is the xsd generated

    <?xml version="1.0"?>

    <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

    <xs:element name="colors">

    <xs:complexType>

    <xs:sequence>

    <xs:element minOccurs="0" maxOccurs="unbounded" name="color">

    <xs:complexType>

    <xs:simpleContent>

    <xs:extension base="xs:string">

    <xs:attribute name="RGB" type="xs:string" use="optional" />

    </xs:extension>

    </xs:simpleContent>

    </xs:complexType>

    </xs:element>

    </xs:sequence>

    </xs:complexType>

    </xs:element>

    </xs:schema>

    The output I get is

    RGB,text

    FF0000,

    00FF00,

    0000FF,

    FFFFFF,

    000000,

    it does not read the valures of the second column.

    What am I missing here? it should work shouldn't it?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply