hello, Bob...
look: in order to pass the variable to the constraint, you must use
doubleclick on the constraint, then, you must select evaluation operation:
expression and constraint, and then put in the expression box, the evaluation
of the variable: @my_var= something... or the evaluation that you need...
be carefull with the logic of multiple constrainst, because they must be the
same for "incoming" constraints...
Saludos desde Colombia...
---
Fredy (Co)
[quoted text, click to view] "Bob McClellan" wrote:
> Thanks Freddy!
> I have been trying to understand how to pass the variable to the constraint.
> That's the essence of my question. Any references you can suggest would
> be much appreciated. BOL is NOT getting me there.
>
> thanks again,
> bob.
>
> "Fredy (Co)" <FredyCo@discussions.microsoft.com> wrote in message
> news:10A8813B-7EB1-4B4E-830F-BF8C683844F3@microsoft.com...
> > you can use a variable that receives the value of Count(exception).. then,
> > you can evaluate that value in the precedende constraint and redirect the
> > control flow....
> >
> > Saludos desde Colombia...
> > ---
> > Fredy (Co)
> >
> > "Bob McClellan" wrote:
> >
> >> I have an SSIS package that emails a spreadsheet exception report.
> >> Naturally, I only want to send it, if there are exceptions.
> >> What can I use to query for the exception and only allow the workflow if
> >> Count(exception) > 0
> >>
> >> thanks in advance,
> >> bob.
Thanks Freddy!
I have been trying to understand how to pass the variable to the constraint.
That's the essence of my question. Any references you can suggest would
be much appreciated. BOL is NOT getting me there.
thanks again,
bob.
[quoted text, click to view] "Fredy (Co)" <FredyCo@discussions.microsoft.com> wrote in message
news:10A8813B-7EB1-4B4E-830F-BF8C683844F3@microsoft.com...
> you can use a variable that receives the value of Count(exception).. then,
> you can evaluate that value in the precedende constraint and redirect the
> control flow....
>
> Saludos desde Colombia...
> ---
> Fredy (Co)
>
> "Bob McClellan" wrote:
>
>> I have an SSIS package that emails a spreadsheet exception report.
>> Naturally, I only want to send it, if there are exceptions.
>> What can I use to query for the exception and only allow the workflow if
>> Count(exception) > 0
>>
>> thanks in advance,
>> bob.
Thanks for the reply and the help Freddy.
[quoted text, click to view] "Fredy (Co)" <FredyCo@discussions.microsoft.com> wrote in message
news:75B5A175-9D40-48C6-9269-1EBA4DC6E6D6@microsoft.com...
> hello, Bob...
>
> look: in order to pass the variable to the constraint, you must use
> doubleclick on the constraint, then, you must select evaluation operation:
> expression and constraint, and then put in the expression box, the
> evaluation
> of the variable: @my_var= something... or the evaluation that you need...
>
> be carefull with the logic of multiple constrainst, because they must be
> the
> same for "incoming" constraints...
>
> Saludos desde Colombia...
> ---
> Fredy (Co)
>
> "Bob McClellan" wrote:
>
>> Thanks Freddy!
>> I have been trying to understand how to pass the variable to the
>> constraint.
>> That's the essence of my question. Any references you can suggest would
>> be much appreciated. BOL is NOT getting me there.
>>
>> thanks again,
>> bob.
>>
>> "Fredy (Co)" <FredyCo@discussions.microsoft.com> wrote in message
>> news:10A8813B-7EB1-4B4E-830F-BF8C683844F3@microsoft.com...
>> > you can use a variable that receives the value of Count(exception)..
>> > then,
>> > you can evaluate that value in the precedende constraint and redirect
>> > the
>> > control flow....
>> >
>> > Saludos desde Colombia...
>> > ---
>> > Fredy (Co)
>> >
>> > "Bob McClellan" wrote:
>> >
>> >> I have an SSIS package that emails a spreadsheet exception report.
>> >> Naturally, I only want to send it, if there are exceptions.
>> >> What can I use to query for the exception and only allow the workflow
>> >> if
>> >> Count(exception) > 0
>> >>
>> >> thanks in advance,
>> >> bob.
>>
Don't see what you're looking for? Try a search.
