best way?

[Fsb]

Hello,

I'm using an Execute SQL Task that may or may not return a value that is
assigned to a variable (via a signal result set). Now if it does not return
a value I still want it to continue. What is the best way to accomplish
this? I set the ForceExecuctionResult property to 'Success' or is there a
better or different way to do this? What is the advantage/disadvantage?

[Todd C]

Forcing the Execution to return Success is one way to do it like you have
described. The other way is to conenct to the next task in line NOT with a
Success constraint, but with a 'Completion' constraint. Simply right-click on
the connector and edit the settings.

If you are logging results anywhere, you may lose the info that a particular
run of the SQL Task failed because it always reprots Success. If you let it
report as Failed, but the next task continues anyway, you can see that in the
logs. (just a minor point).

HTH
=====
Todd C

Post by Fsb
Hello,
I'm using an Execute SQL Task that may or may not return a value that is
assigned to a variable (via a signal result set). Now if it does not return
a value I still want it to continue. What is the best way to accomplish
this? I set the ForceExecuctionResult property to 'Success' or is there a
better or different way to do this? What is the advantage/disadvantage?