Change the Execute SQL task's underlying SQL statements by clicking on the value beside the "SQLStatement" label if the source type is "Direct Input." You can simply edit the SQL in the editor.

Let’s say you have an Execute SQL task and you need to use a large table join to query the source table. There are several ways you can store the queries, and you can even combine some of them.