Hi,
Is it possible to have more than 1 foreach loop container in SSIS 2008? My question is how can I loop through both different text files at same time (i.e., square files that have square patterns and circle files that have circle patterns)? Can I have more than one filespec property? If so, how do I accomplish this? I'm also trying to figure out how to get both different text files that will be looped through using a merge join transformation, so that the output will go into an excel file. Is it also possible to have more than one merge join transformation? Has anyone else done this before?