[Solved] Can I use an Expression to set a variable in a “SQL Statement Task”?

Question

If you are talking about the “Execute SQL Task”, expressions are possible. Here what I usually do is to configure the type as “direct input” and then define the whole statement – including my parametrized values – as expression. If you rightclick the task, you can select properties and in the properties you open the expression popup by clicking the “+” left of “Expressions” and then “…” which appears right of it. Then after selecting the property “SqlStatementSource” you can click the “…” at the right again and enter your expression here.

Accepted Answer

If you are talking about the “Execute SQL Task”, expressions are possible. Here what I usually do is to configure the type as “direct input” and then define the whole statement – including my parametrized values – as expression. If you rightclick the task, you can select properties and in the properties you open the expression popup by clicking the “+” left of “Expressions” and then “…” which appears right of it. Then after selecting the property “SqlStatementSource” you can click the “…” at the right again and enter your expression here.