I think I solved the problem. In my SSIS package the locale was set to German(Germany). So I think the convert expects a "," as decimal separator. I switched the...

I think I found the problem. The problem is that the varchar column uses a point as decimal separator. The destination numeric column expects a comma as seperator. Is there...

Next step was to import the single date column of the flat file into this simple staging table. Loaded the staging data over derived colun and data conversion into the...

So, tested it with a simple staging table one varchar(50) column with just two values, one empty value and one date as varchar. Import into a table with one date...

The problem is that I have another column where I have no empty values and it works. Strange thing...