topic Re: Is there any component to execute T-SQL Script in Talend Studio

Is there any component to execute T-SQL Script

_AnonymousUser — Mon, 05 Nov 2012 12:40:32 GMT

Hi,

I have loaded the data into the MSSQL Server(using Job Design process) and at the end i want to execute T-SQL Script.
Is there any component in Talend Data Integration to execute T-SQL Script.
Thanks.
Regards
Syed Arshad

Re: Is there any component to execute T-SQL Script

Anonymous — Tue, 06 Nov 2012 14:46:18 GMT

tRow
but it depends what (and how) you are trying to achieve it.
tRow runs a SQL script for every row that passes through it.
if you want to run a script at end of a subjob. you will have to trigger its execution.
the round-block way is to have a tFixedFlowInput with a single row (anything will do) to send this ONE row through a tMSSQLRow.
you enter whatever your SQL script should be run in tMSSQLRow.
does it help?

Re: Is there any component to execute T-SQL Script

Anonymous — Tue, 02 Jul 2013 12:42:10 GMT

It's is possible to execute a script with a component tSystem with a command like this:
"cmd /c sqlcmd -S <server_name> -i \"C:\\Users\\script.sql\""
For this command you should have sqlcmd on you computer.