The HasExpressions property is available on all SSIS objects that support expressions, with the exception of variables. The property enables us to easily identify which objects have expressions.
By default the value of HasExpressions is false.
Let’s see
below example
Here we are taking a execute sql task.
Using this
execute sql task we are inserting a record in the table.
Now we are
setting the disable property of this task.
Read More about: Disable property in SSIS
(Dynamically Disable a Task)
Here we are taking the variable as Boolean
Now we are setting the disable flag property dynamically.
Click ok.
Fx logo is create on the task. And HasExpressions property is true.
HasExpressions
is indicate that this task has expression.
Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing
ReplyDeleteMsbi Training
Msbi Online Course