SSIS shows no coloumns in xml document in XML Source



I am trying to get the last date with exsisting exchange rates from National Bank of Belarus using their web service and SSIS. The XML file i receive from NBRB is quite simple:



<?xml version="1.0" encoding="utf-16"?>
<dateTime>2014-12-08T00:00:00</dateTime>


I generate XSD schema for this file in Visual studio:



<?xml version="1.0" encoding="utf-16"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://ift.tt/tphNwY">
<xs:element name="dateTime" type="xs:dateTime" />
</xs:schema>


But when I try to use SSIS XML source to receive this data from the xml file, there is no dateTime coloumn in the Coloumns section.


Can anyone help me with this issue?


No comments:

Post a Comment