I think the limit in SSIS is smaller.

I've had issues with very large SQL statements in Execute SQL Tasks, but they were less than 64K characters if I remember correctly.

If the string is stored in an SSIS variable configured with an expression, prior to SQL Server 2012 the limit was 4000 characters.