Talend Delete Table option does not empty table

Anonymous — Fri, 22 Apr 2016 19:44:19 GMT

Hi,
I am trying to delete table using tmssqlrow component. First i need to delete/trucate multiple tables then I do updata/insert for multiple tables.
I used tmssqltablelist>>>>tmssqlrow>>>tmssqlsp>>>>tmssqlsp. I used delete option in tmssqlrow. It wasn't working If I run the "TRUNCATE TABLE" manually in the SQL Server Management Studio, the job works fine.
option-1: I can create store proc to truncate the table, then i can call the store proc.
Do we have any other options then this? I don't want to use so many SP in the mapping.
Why tmssqlrow delete query is not working?
Thanks in Advance

Re: Talend Delete Table option does not empty table

Anonymous — Mon, 25 Apr 2016 07:52:19 GMT

Hi,
Have you treid "drop table_name" query in your tmssqlrow component to see if it works? Screenshots of your job setting will be preferred.
Best regards
Sabrina

topic Re: Talend Delete Table option does not empty table in Talend Studio

Talend Delete Table option does not empty table

Re: Talend Delete Table option does not empty table