July 6, 2010 at 9:26 pm
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
July 7, 2010 at 3:42 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy