I am pulling a data from XML To SQL through SSIS (Using XML Source). Source field in XML has data type xs:duration and value are as an example "PT00H30M" OR "PT01H00M". However
it is coming through in my destination table as something like "6000000000" or "27000000000".
Any help would be great appreciated.