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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2012-02-06 : 15:44:04
|
| i have loop container that lod excel files.in the container i equal between two variables.how i can make:"if it is not equal then continue else go to next file." |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-06 : 17:01:18
|
| you need to add a dummy task inside the loop (may be a execute sql task with dummay sql statement like SELECT 1), then in its precedence constraint select expression and constraint. leave constraint option as it as (On succes) and in expression give your not equal condition. this will cause tasks inside loop to executed only when condition holds good. if condition does not satisfy it will continue with next iteration without executing any tasks inside------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
if...then in loop