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

preview_player
Показать описание
In this video, we will learn about loading data from multiple XML files to SQL Server Table.
Expression
SUBSTRING(@[User::XmlFilePath], FINDSTRING(@[User::XmlFilePath], "DATA", 1 )+5 , 14 )

You can find me on

#SSIS
#SQLServerIntegrationServices
#XML
#XSD
Рекомендации по теме
Комментарии
Автор

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

kiranshetty-xbmn
Автор

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

gauravraut
visit shbcf.ru