I have a SQL-Agent Job which executes a SSIS-Package. There are Errors in the SSIS-Pakage, but the Job is succeeded.
Here the log for the step:
Executed as user: XXXXX. ....50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 13:53:14 Error: 2012-08-24 13:53:14.97 Code: 0x800470D8 Source: ZEBRA_Stammdaten Description: The result string for expression "@[User:
estPath] + "ZEBRA_Stamm_" + REPLICATE("0",2 - LEN((DT_STR,1,1252)MONTH(GETDATE())))" may be truncated if it exceeds the maximum length of 4000 characters. The expression could have a result value that exceeds the maximum size of a DT_WSTR. End Error The package executed successf... The step succeeded.
So the problem with the SSIS-Package is fixed, but i wonder why the Job is successful despite of this error. Is there a way to avoid this behavior, so that the SQL-Agent Job will fail?