topic Re: Running a TSQL script in Talend Studio

Running a TSQL script

talendstar — Sat, 16 Nov 2024 04:34:07 GMT

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

Re: Running a TSQL script

Anonymous — Wed, 25 Sep 2019 18:04:44 GMT

Hi,

Could you please try tMSSQLRow component? I would suggest you to embed your logic in a Stored Procedure.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved