rip xml data into tables using BIDS

• saqlainkhan

  Ten Centuries

  Points: 1126

  More actions

  January 19, 2010 at 9:56 am

  #215810

  i am trying to import 6000 xml files into a sql table using BIDS. i select XML Source from data flow source and sql server destination from data flow destination.

  specify the location of xml, and then click on generate xsd. and a list of errors are generated. i have attached a file for error generated.

  when i use a trail versio of a tool for ripping xml, it works fine and rips all data into tables, but then again it is a trial version.

  Would appreciate help on this. i will paste a sample xml file. thanks.

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

  - <MSNOnlSvcInfo xmlns:msxml="urn:schemas-microsoft-com:xslt" Version="2.0">

  - <ProviderSettings>

  <FIPID>5010</FIPID>

  <Name>Air Academy FCU</Name>

  <Address1>1355 Kelly Johnson Blvd</Address1>

  <Address2 />

  <Address3 />

  <City>Colorado Springs</City>

  <State>CO</State>

  <Zip>80920</Zip>

  <Country>USA</Country>

  <Phone>1-800-223-1983</Phone>

  <InternetMail>airacad@aafcu.com</InternetMail>

  <Website1>https://www.aafcu.com/</Website1&gt;

  <hfi>{A5FFC4AC-3601-4C86-AF33-91A2D780DA03}</hfi>

  <hfisvc>{7D53364E-4BCA-48CA-AC80-851012F0659E}</hfisvc>

  <DriverType>O</DriverType>

  <StandAlone>0</StandAlone>

  <Org>Air Academy Federal Credit Union</Org>

  <FID>1</FID>

  <AcctListAvail>1</AcctListAvail>

  <ClientActReq>0</ClientActReq>

  <BrokerID />

  <OFXHeaderVer>102</OFXHeaderVer>

  <FullSyncSupp>0</FullSyncSupp>

  <DisallowUSASCIIEncoding>0</DisallowUSASCIIEncoding>

  <DisallowUNICODEEncoding>1</DisallowUNICODEEncoding>

  <DisallowUTF8Encoding>1</DisallowUTF8Encoding>

  <DisallowGenMail>1</DisallowGenMail>

  <DisallowPinChange>0</DisallowPinChange>

  <Min>4</Min>

  <Max>10</Max>

  <Alpha>1</Alpha>

  <Numeric>1</Numeric>

  <Special>1</Special>

  <Spaces>0</Spaces>

  <ChangePin>0</ChangePin>

  <TANRequired>0</TANRequired>

  <ProviderURL>https://remotebanking.aafcu.com/ofx/ofx.dll</ProviderURL&gt;

  <ServiceUpdateURL />

  <SmallLogoURL>https://www.microsoft.com/Money/Money2005/USA/5010.bmp</SmallLogoURL&gt;

  <ProvUpdateDescURL />

  <CommentsTXT />

  <UserIDString>Member Number</UserIDString>

  <PasswordString>Password</PasswordString>

  <ServiceVersion>2</ServiceVersion>

  <StatementLogonURL />

  <PaymentLogonURL />

  <WebServicesURL />

  <BrandingDate>6/28/2005</BrandingDate>

  <FIContentURL />

  </ProviderSettings>

  - <BankingCapabilities>

  <Bank>1</Bank>

  <BankMail>0</BankMail>

  <IntraXferCanSched>0</IntraXferCanSched>

  <CreditCard>0</CreditCard>

  <DfltDays>0</DfltDays>

  <IntraXferSupp>1</IntraXferSupp>

  <IntraSyncSupp>0</IntraSyncSupp>

  </BankingCapabilities>

  - <BillPayCapabilities>

  <Pay>0</Pay>

  <BillPayMail>0</BillPayMail>

  <DfltDaysWith>0</DfltDaysWith>

  <DfltDaysToPay>0</DfltDaysToPay>

  <XferDfltDaysWith>0</XferDfltDaysWith>

  <XferDfltDaysToPay>0</XferDfltDaysToPay>

  <IdDfltDaysWith>0</IdDfltDaysWith>

  <IdDfltDaysToPay>0</IdDfltDaysToPay>

  <CountNonBusDays>0</CountNonBusDays>

  <PmtByAddr>0</PmtByAddr>

  <PmtByXfer>0</PmtByXfer>

  <PmtByPayeeID>0</PmtByPayeeID>

  <DisallowRecPmt>1</DisallowRecPmt>

  <DisallowCreditCardPmt>1</DisallowCreditCardPmt>

  <UseProcessDateModel>0</UseProcessDateModel>

  <BillPay2AddrLines>0</BillPay2AddrLines>

  </BillPayCapabilities>

  - <InvestmentCapabilities>

  <BrkStmt>0</BrkStmt>

  <InvMail>0</InvMail>

  <DisallowInvTranDownload>1</DisallowInvTranDownload>

  <DisallowOODownload>1</DisallowOODownload>

  <DisallowPositionDownload>1</DisallowPositionDownload>

  <DisallowInvBalanceDownload>1</DisallowInvBalanceDownload>

  </InvestmentCapabilities>

  - <PinWiz>

  <SignupType>2</SignupType>

  <URLPin />

  <PhonePin>1-800-223-1983</PhonePin>

  <Charge>0</Charge>

  <ChargeFrq>1</ChargeFrq>

  <ConnectionSurchargeLimit>0</ConnectionSurchargeLimit>

  <UsesWebPwd>1</UsesWebPwd>

  <SeparateEnroll>0</SeparateEnroll>

  </PinWiz>

  </MSNOnlSvcInfo>

  Noli Timere

• January 19, 2010 at 11:59 pm

  This was removed by the editor as SPAM