Toad World® Forums

Substitution variables for SQL filename

Using automation - is there a way to use substitution variables in the SQL file name in the Export Wizard. ie. ISValueCounts#VarFieldName#.sql? This approach did not work - is there another way?

Hello,

Unfortunately the variable substitution isn’t supported in this particular case. But I think you can use the Copy File activity (which supports the substitution) as a workaround.

For example: First add the Copy File activity, which copies ISValueCounts#VarFieldName#.sql to xxx.sql. And then use the “static” file name xxx.sql in the Export Wizard.

Libor

Brilliant- thank you

Sent from my iPhone

On Nov 1, 2017, at 4:16 AM, Libor.Witasek bounce-LiborWitasek@toadworld.com wrote:

RE: Substitution variables for SQL filename

Reply by Libor.Witasek
Hello,

Unfortunately the variable substitution isn’t supported in this particular case. But I think you can use the Copy File activity (which supports the substitution) as a workaround.

For example: First add the Copy File activity, which copies ISValueCounts#VarFieldName#.sql to xxx.sql. And then use the “static” file name xxx.sql in the Export Wizard.

Libor

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad Data Point Forum notifications altogether.

Toad Data Point - Discussion Forum

Flag this post as spam/abuse.