SQLServerCentral / SQL Server 2005 / SQL Server 2005 Integration Services / String Literal in the expression exceeds the maximum allowed length of 4000 characters. / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 18:25:28 GMT20RE: String Literal in the expression exceeds the maximum allowed length of 4000 characters.http://www.sqlservercentral.com/Forums/Topic1355060-148-1.aspxEverything the fellow reponder (PP) said :Break doen into smaller queriesWrite short expressions(maybe even shorter variable names)Parametreized stored procMight i also suggest :Have a .sql file in which you write out your command and then have your ssis execute that instead.A long winded way but will work.Thu, 13 Sep 2012 13:01:44 GMTn79799RE: String Literal in the expression exceeds the maximum allowed length of 4000 characters.http://www.sqlservercentral.com/Forums/Topic1355060-148-1.aspx1) Break down into multiple queries.2) Use fewer characters.3) Call a parameterised stored proc to do the work for you.Thu, 06 Sep 2012 03:00:15 GMTPhil ParkinString Literal in the expression exceeds the maximum allowed length of 4000 characters.http://www.sqlservercentral.com/Forums/Topic1355060-148-1.aspxHi All,I need a small help. In my ssis package, huge SQL statement is constructed through expressionsProblem:SQL is exceeding more than 4000 characters.Could anyone please share the thoughts / work around to resolve the issue.Thanks in advance.Thu, 06 Sep 2012 00:51:34 GMThamsa_apj