Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie123
Starting Member
1 Post |
 Posted - 2009-05-11 : 15:00:10
|
| Hi,I have some similar XML files which need to be read in a loop (number of XMLs to be read is not fixed). How can I read them in a loop in SSIS.ThanksRookie |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-05-11 : 15:40:41
|
| You will need a For Each Loop container, and within the container under "Collection" choose For Each File Enumerator, and then tell it where the files are. Jim |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-05-11 : 19:35:02
|
| Sorry, I got called away mid posting. You'll also need to set up some variables. Are you familiar with this?Jim |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Reading XMLs in a loop