I set up a very simple automation using the ‘Set Variable’ activity to set a parameter, followed by the ‘Select to File’ activity, which runs a very simple script against an Excel tab:
select * from AutoRange_A where measure= ‘Timeliness’ and cnty_nm = :county
select * from AutoRange_A where measure= ‘Response’ and cnty_nm = :county
Toad crashes immediately anytime there’s more than one parameter in the ‘Select to File’ activity and the database is Excel. If I run just one of those lines, it works fine.
It still crashes if I rename the second parameter to :county2.
This is TDP 3.5