fix missing value

Can SSIS detect the missing value and replace it with some reasonable value (e.g., maximum, median, average, etc.)?
thanks

You haven't given enough information.
Where is the missing value?

|||Sorry that I was not clear. The missing value exists in a table. For example, one column of one row does not have any data. This can cause problem when I try to use this table for some task, e.g., train a data mining model. So I want to find a way to detect these places and fill them with some reasonable value.
Thanks|||If you just want to fix these values in the table then just issue an T-SQL UPDATE statement:
UPDATE MyTable
SET MyField = ISNULL(MyField, <some_value>)
or
UPDATE MyTable
SET MyField = <some_value>
WHERE MyField IS NULL
This can be issued from an SSIS Execute SQL Task if you so desire.

If you are moving this data to somewhere else using SSIS and you want to eliminate the missing values as the data is being moved then include a Derived Column Transform in your data-flow which can be used to replace a missing value using an expression.
The expression builder is fairly intuitive but if you have any trouble then reply here and people will be able to help out.

-Jamie|||
Thanks.

But if there is a way that SQL Server can automatically figure out a reasonable value used to fill in the missing value? I mean I do not need to specify a value to replace the missing value, but SQL Server will figure out one

Thanks|||

Yanbing Hu wrote:

Thanks.

But if there is a way that SQL Server can automatically figure out a reasonable value used to fill in the missing value? I mean I do not need to specify a value to replace the missing value, but SQL Server will figure out one

Thanks

Well surely that depends on your criteria for deciding what the missing value is. Can you give an example?

-Jamie|||You might be refering to the default value that can be specified per column in the CREATE TABLE statement itself.