SSIS: Integration Services XML as Source

  • 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

  • Presumably you tried setting the UseInLineSchema property to false?


Viewing 2 posts - 1 through 2 (of 2 total)

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