Post reply

Help with XML Data Source Error

  • February 19, 2008 at 4:40 pm

    #184103

    Pasted below is an error message I received in using a XML Data Source. My XML file was generated by Crystal Reports XI using the Crystal ML Schema.

    Can anyone suggest the best way to modify my XML file so that SSIS will accept it as a properly-configured XML Data Source?

    Thanks,

    Sid

    TITLE: Microsoft Visual Studio

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

    Error at Data Flow Task [IPSLRFY08Q1 [55]]: There was an error setting up the mapping. The root element of a W3C XML Schema should be and its namespace should be 'http://www.w3.org/2001/XMLSchema'.

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

    ADDITIONAL INFORMATION:

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

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

    BUTTONS:

    OK

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

  • February 20, 2008 at 3:20 pm

    #780433

    send your XML file here and we will have a look.

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • February 20, 2008 at 4:58 pm

    #780457

    Valek,

    Pasted below is the beginning of one of the XML files, using just the first record.

    Thanks for checking this out.

    <Report xmlns = 'urn:crystal-reports:schemas'

    xmlns:xsi = 'http://www.w3.org/2000/10/XMLSchema-instance'

    xsi:schemaLocation = 'urn:crystal-reports:schemas SLR_FY07Q4_By_Hospital.xsd' >

  • February 20, 2008 at 5:07 pm

    #780458

    Apparently, the last post didn't dispaly the full block of code. Please see the attached .txt file.

    Thanks,

    Sid

  • February 20, 2008 at 6:28 pm

    #780465

    Sid Childers (2/20/2008)

    Apparently, the last post didn't dispaly the full block of code. Please see the attached .txt file.

    Thanks,

    Sid

    First of all, your XML is invalid. There is some garbage in the beginning and the end, looking like

    Remove if from there.

    Secondly, even if you remove this from the file, you will end up with a broken XML file. There are two tags that are not closed in the end of the file - ReportArea and Report. So stick the closing tags for ReportArea and Report to make the XML valid. (this forum cuts tags, damn it)

    Thirdly, SSIS needs data structure definition to be either in a separate XSD file or inline. Which means that if you don't have this XSD matching the info in the XML file, you need to make sure that the XML has it inside. Read here about what XSD is all about. You can actually create one manually or generate it, but I am not sure how...

    Hope it helps

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • February 21, 2008 at 2:15 pm

    #780862

    Here's what I've learned thus far:

    SSIS had a problem with the .xsd file generated by Crystal Reports XI. The schema SSIS needs is dated 2001 or later, and the .xsd generated by Crystal is dated 2000.

    I tried a different approach by exporting the Crystal Report to a .csv format. I'm now editing the .csv to make it work with SSIS by eliminating headers, footers etc.

    Question: I'm using Crystal Reports XI 11.0.0.1282. Is there a patch to Crystal that generates a .xsd that is compatible with SSIS/Visual Studio?

    Thanks,

    Sid

Viewing 6 posts - 1 through 5 (of 5 total)

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