I have a complex XML file (a few nested sections). The XML file is fairly large around 5GB.
Just asking overall what is the fastest way to get the XML data into tables inside SSIS?
The way I have it working now is using a standard Data Flow with XML Source which loads into two staging tables.
Would it be better to find a way to bulk load it and then process it into two tables?
What is the best / fastest method?
View Complete Post