Saturday 12 September 2020

HasExpressions property in SSIS

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.

1 comment:

  1. Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing

    Msbi Training
    Msbi Online Course

    ReplyDelete

If you have any doubt, please let me know.

Popular Posts