title: SSIS Derived Column IS NOT NULL with Or expression
body: <p>I need assistance writing an Derived Column expression that meets this criteria.</p>
  
  <p>IF ([Name of Job] is  "Accenture Leadership" OR "Senior Executive") AND [Pay scale Group] IS NOT NULL THEN  [Pay scale Group] ELSE [Name of Job].</p>
  
  <p>Thanks,</p>