Suppressing warnings about null fields

I am converting about 2 million records for delimited text to SQL Server. Most records contain 300 fields and several of these fields are likely to contain null values. When these are converted to integer, date or decimal SQL fields I get a warning like "The value [] unable converted to date!", There are about 10 warnings for each of the 2 million records, and they are not a concern. However there are so many messages I cannot tell if there are some other important warning messages (e.g. about truncation). Is there a way I can suppress or eliminate these Null warnings without suppressing other warning messages?
I would appreciate any advice you can give me.
Thanks!

Hello Michael,

I’m wonder why till now no one complain about this strange feature :unsure: Of course this makes no sense. In case the SQL Server field allows DBNULL no warning should occur if an empty string is the value.

I’ve made a short modification. You can download a fixed version here

FlowHeaterBeta 32 Bit
FlowHeaterBeta 64 Bit

Note: It´s planned to release the next official version latest end of April.

Thanks!

I really appreciate the fast response.

I installed the 64-bit version and tested it.

The write messages about nulls are now suppressed but I am still getting all of the read warnings messages for null fields. There are over 20 million of them!

Is it possible for you to suppress the read warnings too?

Mike Orr

Hello Mike,

In the TextFile Adapter on the READ side you just have to switch the defined data type to “String”. Only in special cases you have to define the exact data type for CSV files . FlowHeater needs just the right format (defined on READ) to transform the containing string value to the desired once on the WRITE side.