I'm working on a process to import XML files into flat table using SSIS. I've been trying to make use of the Built in XML Datasource. I have it working to an extent but it seems somewhat slow and cumbersome due to a number of sorts I need to add in order to get the related elements joined and into the correct format to write it to my flat table.
I've seen a number of people online suggesting other third party Tools (CozyRoc, ZappySys etc) to make this development effort easier and to work around some of the limitations of the Built in functionality.
Has anyone used any of these plugins and what were the pros/cons you found while using them.
To help us help you read this[/url]For better help with performance problems please read this[/url]