i have created an Automation script using a SQL that inserts data into the table by using Execute Script activity. For whatever reason when I test the Automation script data is not getting inserted even though I don’t get any error messages. “0 rows affected”. When I ran the query in the Editor window it inserts data into the table.
Any advice is greatly appreciated.