Loading data from multiple XML files to SQL Server Table | SSIS | SQL Server Integration Services

[@kiranshetty-xb8mn]

Thank u so much🙏

[@kiranshetty-xb8mn]

Hi Thanks for video. if we are using XML task how can we validate multiple files. Can u please let me know

[@gauravraut1613]

If suppose data in every xml file has the same column for ex. File 1 name is Employee1 and file 2 name is manager1 but both files contains the same data but name is different then how to dynamically insert both files data together in the same table

[@SatyarthProgrammingHub]

Thanks for your comment. This video teaches you the same. Whatever your filename is, as long as they have the same schema package will load it. In this video, in the foreachloop we have taken "*.xml" in files, this means filename does not matter, as long as file has ".xml" extension, package will try to load it. Hope this resolves your doubt.