Does the "Before Script" and "After Script" in JDBC writer step support parameterisation?

Question

I have a use case to use the JDBC writer step to write some data into a MS SQL db.

I will need to use the Before and After script feature. (Truncate the table in the before script, then I need to call a stored proc in the after script).

And in the after script, I need to construct that based on some value that I calculate in the plan. So it is different every time I run the plan, but I need to keep it consistent.

Does this after script support some parameterisation? I have a feeling it won’t but wanted to double check.

AKislyakov · Accepted Answer

Hi@maykwok_hamiltonNo, before and after scripts are executed only once and thus do not accept any parametrization coming from the plan. Whatyou can do is indeed define before and after scripts as parameters and pass those from the workflow.

may_kwok · Answer

If the answer is no then I think I’ll need to wrap this in a .ewf and parameterise it into the Execute SQL task. Just wanted to check that I need to go down this approach?

Reply

Sign up

Login to the Ataccama Community

Scanning file for viruses.

This file cannot be downloaded