How to parameterize SSIS Task Property using Expression to make it dynamic

In this article we will show you how to parameterize SSIS Task Property using SSIS Expression Engine.

1. Right click on Task > Select Properties 
2. Find out Property Name you like to make dynamic and copy value (we will need it later)
3. Now click on Expressions [...]
4. Select Property name 
5. Click on [...] in the Expressions column
6. Now you can write your expression and Click OK

Findout SSIS Task Property to make it dynamic

Choose Property for Expression

Write SSIS Expression

SSIS Task with Expression will show fx icon overlay like below

Expression on Data Flow Component Property

If you want to make data flow component property dynamic then there are slightly different steps listed in below article

https://zappysys.com/blog/ssis-dataflow-expression-source-component-property/

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/