How to parameterize a custom SSIS component
I am developing a custom SSIS component, a data source to be precise. Now, I have almost everything in place - the component takes one input parameter (custom property), which is a string. As this parameter will change depending on the environment, it is crucial for me to parameterize it with an expression that would assign it a value from a package parameter.
Of course when I right-click on my component in the data flow, there is no "Parameterize..." option. I noticed that in commercial components, such as Cozyroc, it is handled through data flow property expressions, but my "Process URL" is not visible as a property that could be assigned with an expression.
How can I enable parameterization on my custom property? I am using SQL Server 2012 as a target platform for my projects, the component itself is written in C#.
When you define your custom property for Process URL, you should set its property .ExpressionType = DTSCustomPropertyExpressionType.CPET_NOTIFY. More details you can find here in Microsoft Documentation on Custom Data Flow component.
Once you set this, your custom property will be available at DataFlow expressions.