Warning: Null value is eliminated by an aggregate or other SET operation in SSIS package failure

• PJ_SQL

  SSCertifiable

  Points: 6703

  More actions

  April 23, 2016 at 8:54 am

  #318433

  SQL Job executing the SSIS package failed with this error message:

  Warning: Null value is eliminated by an aggregate or other SET operation.

  Does it mean the SSIS package executed all the steps successfully but with above warning?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736254

  More actions

  April 23, 2016 at 12:55 pm

  #1874093

  Yes, this is a warning that you should understand if you are using an aggregate (SUM, AVG, etC), that the row with a NULL value is not included.