SSIS: Integration Services XML as Source

• tasnim.siddiqi

  Ten Centuries

  Points: 1063

  More actions

  July 6, 2010 at 9:26 pm

  #234880

  Hi Guys,

  I have converted an MS .xlsx file to .xml file. Now I chose the xml file as a data source for my integration services project with SQL Server as destination. Problem is when I chose the XML file in the XML Source Editor, I get the following error message:

  Error at Data Flow Task [XML Source [633]]: The XML Source Adapter was unable to process the XML data. No inline schema was found in the source XML, but the "UseInlineSchema" property was set to true.

  (Microsoft Visual Studio)

  ===================================

  Pipeline component has returned HRESULT error code 0xC02092A3 from a method call. (Microsoft.SqlServer.DTSPipelineWrap)

  ------------------------------

  Program Location:

  at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HandleUserException(Exception e)

  at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper90 wrapper)

  at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData()

  at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.ReinitializeMetadata()

  at Microsoft.DataTransformationServices.DataFlowUI.XmlSourceUI.connPage_SaveConnectionAttributes(Object sender, XmlConnectionAttributesEventArgs args)

  Can anyone help me how to get rid of this error. As far as I can understand, there is some form of validation with the XML file. I am kindof lost here.

  Any help will be greatly appreciated

  Thanks in Advance

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  July 7, 2010 at 3:42 am

  #1189497

  Presumably you tried setting the UseInLineSchema property to false?

  ---