DATEADD returns a null result if the argument is null. Errors occur if a date is invalid, if the date or time unit is not a string, or if the increment is not a static integer. SSIS Expression ...

Desired behavior for this function is beyond just accepting columns-variables: it has to work with any nested logic depending on user defined data in other columns, e.g. DATEADD(NOW(), ...

=DATEADD(DimDate[FullDateAlternateKey], 100, day) What I noticed was that it only worked for some dates and not all; for example, in the screenshot above it works up to September 22nd and not ...