Is it possible for a Dynamic type output to allow null values

[aaronrums]

I am using a Dynamic type output as the single schema field for a SQL Server tDBOutput column.

I have noticed that if a null value comes in from the query, that column is not added to the dynamic output, almost as if it is ignored.

Is it possible to avoid this? I know that I can default the values using ISNULL or COALESCE in SQL, but I would like to avoid this because we may want to know when the value from the source is actually null.

Thank you kindly!

Aaron

[Anonymous]

@Aaron Rumley​ , I think we need to check what's the real value is read from the source using Dynamic schema if a null value comes from the source. To access the column properties and get the column value, please refer to this KB article.

[aaronrums]

thanks, that's a helpful article to start with.