You cannot see this in SSIS itself.

You'll need to go to the database and check if the query was executed.

You could also use SQL Server Profiler to verify if the query has been sent to the database correctly.

Or you could implement some auditing in the query itself.

The Execute SQL Task will only tell you if the query has been successfully executed or not and how long it took.