Home Forums SQL Server 2005 SQL Server 2005 Integration Services String Literal in the expression exceeds the maximum allowed length of 4000 characters. RE: String Literal in the expression exceeds the maximum allowed length of 4000 characters.

  • September 6, 2012 at 3:00 am

    #1534315

    1) Break down into multiple queries.

    2) Use fewer characters.

    3) Call a parameterised stored proc to do the work for you.