all groups > sql server dts > february 2006 >
You're in the

sql server dts

group:

branching



branching Andre
2/21/2006 4:55:25 PM
sql server dts: 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

Re: branching Andre
2/21/2006 5:30:40 PM
Fuhgetit - I figured out how to disable a step, and this is what I needed.

Andre

AddThis Social Bookmark Button