Phil Parkin (11/18/2013)
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.
I have. 😀
A lot of views with a lot of columns strung together with UNION ALL.
When using expressions to create dynamic SQL, you can hit the limit of 4k characters pretty fast.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP