Koen Verbeeck (11/18/2013)
Phil Parkin (11/18/2013)
Batch size.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.
Interesting. My ExecuteSQL statements are usually very short, so I have not come up against any limit.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.