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.
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
