Post reply

XML Data Source

  • February 18, 2010 at 2:12 pm

    #145299

    Hi,

    I have a XML file that I would like to import into a SQL Server table. I've added the XML Data Source and connected it to my .xml file, but no columns appear.

    I know nothing about XML formats, so i'm not sure what else to try.

    Here is the xml file:

    <ControlFile>

    <FileName>U1050266_20100217.zip</FileName>

    <FileSize>1105948364</FileSize>

    <FileDeliveryDate>2010-02-17T19:31:41</FileDeliveryDate>

    <BackupType>Full</BackupType>

    </ControlFile>

    Any help would be appreciated.

    Thanks,

    Jeff

  • February 19, 2010 at 1:34 pm

    #1122110

    Have you configured the XSD Location to point to a valid XML Schema document? This is where SSIS will read the column for your XML data sets.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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