Read SQL Query from file

[jensej]

Hi!

Im trying to import a .sql file into a variable and then use the variable inside the DBInput but can't get it to work.

Why can I only save the path or error message and not the content in the global variable?

Am I on the right track or does someone has another solution? I just want to write my sql query outside the job and then pass it into the DBInput.

[InfoCraft · Accepted solution]

Hi @Jens Frejd​,

Please check this post: https://community.talend.com/s/feed/0D55b00007VVDgfCAH?language=en_US

Kind regards,

😷19.

[jensej]

Perfect thanks!