In scenes where the Proxy method is used for the target database TDSQL for MySQL connection, DTS executes SQL by combining multiple statements into one SQL. You need to set the parameter gateway.mode.multi_query.open to 1 to support the merging of multiple SQL. If the parameter is not enabled, the pre-verification task reports an error.
Fixing Solution
Users cannot modify it by themselves. Submit a ticket for modification.