Ssis Variable 4000 Character Limit And Spliting It Into Two Variables

can someone explain to me why the variable expression in SSIS 2012 is at 4000 character limit? What would happen if it does go over that amount? I understand that there are other

Solution 1:

Yes. It is a limitation. create the separate variables storing sections of your query for the Data Flow Task, and then use the script task to combine them all into a final variable at runtime. Refer this. http://www.texastoo.com/post/2009/07/27/SSIS-workaround-for-the-4000-byte-character-limit.aspx