Nvalid Length Parameter Passed to the Left or Substring Function.
--This call does not return an integer type SELECT iItemid V RTRIMLTRIMSUBSTRINGiShortDescription 25 SUBSTRINGiShortDescription 25 CHARINDEX- iShortDescription 25 AS. Msg 537 Level 16 State 2 Line 12 Invalid length parameter passed to the LEFT or SUBSTRING function. Sql Substring Function And Its Performance Tips Change that and your query should work fine. . While running the query with the same data in SSMS i am not getting any errors and it is giving the successful results but while executing the same query through SSIS packages scheduled in SSIS server. Select tablename leftminsPATINDEX_extract mins-1. While working on a very big stored procedure I found an error saying Invalid length parameter passed to the LEFT or SUBSTRING function. Msg 537 level 16 state 3 procedure recover_truncated_data_proc line 113 invalid length parameter passed to the LEFT or SUBSTRING function. While running the query with the same data in S...