Data Stream Out Error

[keithr197]

Hi Everyone 

Im currently working on a workflow, however i received an error i havent seen before on my data stream out tool. Please see below.

Any advise or assistance would be much appreciated.

[RishiK]

@keithr197 This normally comes about when you are doing a numerical calculation (sum, average, etc) with NULL values.  If you have NULLs in your data, then usually this error is thrown.

Check out this link which shows you a few examples:

https://blog.sqlauthority.com/2015/02/13/sql-server-warning-null-value-is-eliminated-by-an-aggregate...

Can you let us know what you are doing before you Stream Out?