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