June 25, 2007 at 1:46 pm
HI
I have a file loop container that is run against a directory and looks for *.log files.
What I am looking to do is to process 100 files and then leave the container.How do you do this? Must I use ActiveX?
How would you go about this.
I am havin problems with a SSIS package that I think was converted from DTS. Would it be better to start from scratch. It is behaving pretty strangely
June 26, 2007 at 2:50 am
As a side note, there is a memory leak bug with the loop container. This might have been fixed with sp2 - I'm not sure.
if you want to limit your number of loops, use a contain as a starting point in your loop. Then using a precedence constraint, have a condition to check the value of a variable. Increment the variable during each loop.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply