import data from xml using ssis

• ForumUser3

  Default port

  Points: 1415

  More actions

  May 23, 2014 at 7:03 am

  #291662

  Using Sql Server 2012 STD edition, SSDT (Visual Studio 2010 shell, .net framework 4.0.3 SP1

  I am trying to import data from an xml file using ssis.

  Here are the three options I tried and none worked. Please see errors that I encountered in all options and let me know what I can do to import this data in sql server.

  I created a new ssis project with an ssis package. I pulled a data flow task on the control flow. On the data flow tab I pulled an xml source and a sql server destination. Now I tried to configure the xml source task in the the following three ways, but none worked.

  1. I browse the xml file to set xml location. Browse the xsd file to set xsd location, then click ok. I get the following error:

  HRESULT errorcode 0xC02090CF from a method call. There was an error setting up the mapping. Undefined complex Type 'gml_V4.1_Release:PolygonType' is used as a base for complex type extension

  2. I browse the xml file to set xml location. check "Use inline schema" Click ok. Error:

  HRESULT errorcode 0xC020929E from a method call. The xml source adapter was unable to process the XML data. Multiple inline schemas are not supported.

  3.I browse the xml file to set xml location. Click "Generate XSD". Error: The supplied xml instance is a schema or contains inline schema. The class cannot infer a schema for a schema.

  Thank you for your help.

  Forum User:cool:

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  June 16, 2014 at 2:02 pm

  #1722096

  You have to transform the input XML file before trying to read with the XML Source component. Check this post.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/