Was happening in 2.7 and still now in 3.0.
Have Automation script with three tasks.
Insert SQL query
Update SQL query.
In the log notes at bottom is says both queries return 0 records.
After completing when I query the related tables the Insert and Updates do not appear.
However, if I reconnect to the Database in the connection area I am prompted to commit changes. When I accept and reconnect, the inserts and updates appear.
How and where can I make the sql changes seamless/commit without having to reconnect.
Again, the log says the queries return 0 records.