SQLTeam.com | Weblogs | Forums

XML To SQL Through SSIS


#1

Hi Guys,

Need urgent help. I am loading data from XML to SQL through SSIS. Everything looks good except
One field. Dur and data type in .xml is DURATION. Is anyone can help me or guide me how can I
convert Duration into time in SQL.
FYI I am using XSD Schema file for this file. Is there a way I can change the XSD file (Dur Data type) ?

Please advise.

Thank You.