Problem
When you execute an SQL task that includes multiple SQL commands, the following error message (for example) may display:
Solution
Multiple queries, by default, are disabled for MySQL. To enable multiple queries, append the following string to the Connection URL field in the Database Connections resource definition:
The following example is a URL connection string for a MySQL Database Connection resource definition: