How to read dynamically Sql Task properties?

Hi everyone,

I’d like to read the SqlStatement property for a Sql Task from a Script Task (previously Sql Task is executed) in execution.

Keeping on mind that such SqlStatement receives an input parameter.

Is it possible? I think so but how do I such thing?

Let me know if you need further details.

Thanks a lot for your time and thoughts,

I don't think you can get it directly from the task, but you could change the task to take its SqlStatement from an expression-based variable. You'd be taking the parameter mapping into your own hands via the expression, but the variable would be available to your script. You'd just need to be sure that at the point you read the SqlStatement variable, the other parameter variables have settled values.