We input data from CSV file and sometimes decimal columns can be null. SSIS DT_DECIMAL or DT_NUMERIC seems not to be accepted null, got -1071607689, DTS_E_OLEDBDESTINATIONADAPTERSTATIC_CANTCONVERTVALUE error.
May I ask we need to use DT_STR column instead, or is there any required setting for it? Thanks for all of your advice.