Custom Task - Custom Property Expression

I am writing a custom task that has some custom properties. I would like to parameterize these properties i.e. read from a varaible, so I can change these variables from a config file during runtime.

I read the documentation and it says if we set the ExpressionType to CPET_NOTIFY, it should work, but it does not seem to work. Not sure if I am missing anything. Can someone please help me?

This is what I did in the custom task

customProperty.ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY;

In the Editor of my custom task, under custom properties section, I expected a button with 3 dots, to click & pop-up so we can specify the expression or at least so it evaluates the variables if we give @.[User::VaraibleName]

Any help on this will be very much appreciated.

Thanks

Are you by chance actually referring to a Custom DataFlow Component? If so, the expressionable properties actually show up on the DataFlow Task container. To edit the expressions, select the DataFlow and open properties. Find the Expressions property and open the Property Expressions Editor. You should see your custom component's expressionable properties in the Property dropdown.

Let me know if this answers your question.

Thanks
Mark

|||Thanks, got it. I tried the same earlier, but did not drag & drop my new component after the change.sql