Is there a way of repersenting this stagement in the EvalExpression

@LoopCounter > @MaxRecordCount OR @RecordCountLeft > 0

@LoopCounter increments 1 each record
@MaxRecordCount is the maximum records that should be in the record set
@RecordCountLeft is the number of records left after the data flow tasks
has run it the forloop

I trying to make sure that the for loop statment doen't stay in the loop is
a record can not be removed.

Also is there a simple task the will allow the user to reasign a value of a
Variable?

Cheers

Hello John230873,


Have you tried

@LoopCounter > @MaxRecordCount || @RecordCountLeft > 0


Allan

I have and it didn't give me an error but I thougt || was AND what is a OR ?

"Allan Mitchell" wrote:

Hello John230873,

&& = AND


Allan

Allan, I have almost finished the SSIS package to move not copy data, I
haven't seen any thing like it and thought maybe it can help other people,
any idea where to post it?


"Allan Mitchell" wrote:

Hello John230873,

If you think this will help others then why not put it up on wiki.SQLIS.com

Allan