tSQLtemplante: Can not add skript

[NNot_defined1665392384]

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?

[anselmopeixoto]

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?

[NNot_defined1665392384]

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

[NNot_defined1665392384 · Accepted solution]

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