topic Re: tSQLtemplante: Can not add skript in Data Quality

tSQLtemplante: Can not add skript

NNot_defined1665392384 — Fri, 15 Nov 2024 21:25:56 GMT

So i would like to use the tSqlTemplate componente to delete all entries from a MySql database table. Should be simple enough (see sql template job.png). Here is what the template looks like (template.png).

However i can't do anything with it, since i am unable to select it (it's in german, the greyed out button "Hinzufügen" mean "Add", so i can not add a custom skript)

in tSQLtemplate component (sqltemplate component). So what am I missing here?

Re: tSQLtemplante: Can not add skript

anselmopeixoto — Mon, 04 Sep 2023 17:03:52 GMT

Hello @Not defined Not defined

This issue probably isn't related to the sql template you've created, because the tSQLTemplate component should display all the default templates as well. I've tried a similar design and you can see the options available on the attached screenshot.

Did you copy this component from another job or did you add it to the job from scratch?

What version of Studio are you using?

Re: tSQLtemplante: Can not add skript

NNot_defined1665392384 — Mon, 04 Sep 2023 17:06:39 GMT

From scratch and 8.0.1 TOS. Might this be available for the payed version only? What version do you have? BTW I also tried it on two other systems with TOS 7.3 and also 8

Re: tSQLtemplante: Can not add skript

NNot_defined1665392384 — Mon, 04 Sep 2023 17:24:13 GMT

For no apparent reason, now it works. So much appreciate any time!