branching -
02-21-2006
, 06:55 PM
SQL2k
I have a package that I would like to branch 1 of 2 ways, depending on the
results of a step.
My package works something like this:
- determine the number of rows in a table. this is done by running a sql
exec task and populating a global var.
- based on the number of rows, I either want to send an email and quit, or
continue on with the rest of the package like I normally would.
Can anyone tell me an easy way of accomplishing this?
Thanks, Andre |