I would like to have a SSIS package which loops through each xml file (.xml files) in a folder on the network. And then for each file pull out the data and insert into a sql server table.
Please kindly guide me through this i.e. What task(s) are required, etc.
Thanks
ssis - process xml files
Hot Topic
- Unlock account from Management Studio does not work!
- Table visibility problem
- Aggregation Storage Question
- SQL Server 2003
- Looking for SQL server 6.5
- Copy Database Wizard Error- SQL Server Agent cannot execute the SSIS package
- restore from a differential backup
- SQL Server 2005 | Queries Going Into Suspended Mode
- Transferring data from AS400 - Please Help!
- better table management (partitions?)
ssis - process xml files
Hemant Hindlekar
If all files have same structure; I would use a Foreach loop conatiner to loop through all files in the folder; then inside use an xml source component to read the file. Notice that the xml source would need an expression to make the file name dynamic as the file name changes on each iteration.