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