February 18, 2010 at 2:12 pm
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
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply