Using the XML Task component in SSIS we can apply XSLT to the input XML file. Recently we had a requirement to read data from XML file and create/update corresponding records in Dynamics 365 CE. For the child entity tags in the XML, we wanted to insert some of the tags (key) from the parent … Continue reading "Applying XSLT transformation using the XML Task in SSIS"