Merge complex XML datasource to multiple OLEDB destinations with SSIS
Iam having a very large complex XML file. The xml file contains many nodes where i have to insert the xml values in to nearly 25 SQL tables, and there is primary and foreign key relationship for many tables.
How to load that xml file in to multiple OLEDB destinations.?
Please forward if you have any screenshots for this task.