topic SQLServer SQL (TSQL) script in Talend Studio

SQLServer SQL (TSQL) script

Anonymous — Sat, 16 Nov 2024 04:29:27 GMT

Hello all people,

I have SQLServer SQL (TSQL) script which I would like to run from Talend. Is it possible to execute SQL scripts (that contain variables, create temp tables etc) from within Talend. If so which component can I use to execute the script. I am using version 7.1.

Thanks in advance!

Re: SQLServer SQL (TSQL) script

TRF — Thu, 03 Oct 2019 07:17:46 GMT

You need to embbed your SQL script into a .sh or .bat script and call this one from tSystem component.

Re: SQLServer SQL (TSQL) script

TRF — Fri, 04 Oct 2019 08:37:25 GMT

@lawlietlemars, did it help you?

If so, thank's to mark your case as solved.

(Kudos also appreciated)