One Star

Is there any component to execute T-SQL Script

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
2 REPLIES

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

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?
One Star DmB
One Star

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

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.