Are you doing this in the Control Flow design screen or are you down in a data flow?  Package variables don't have a 4k limit. That only applies to fields in a data flow....

Have you tried splitting your query across 2 or more variables and then concatenating them together using the Expression syntax on the SQLStatementSource property?

Sounds lilke you need to build your entire query in a Scripting Task and put the query in a variable.  Then set the SQLSourceType property of your Execute SQL Task to...

Sounds lilke you need to build your entire query in a Scripting Task and put the query in a variable.  Then set the SQLSourceType property of your Execute SQL Task to...

There is a set of C# coding examples that come with the SSIS installation. I believe that you install them from the start menu after the initial SSIS install is...