This error appeared after I added 50 columns to a table, all of which are float(53), i.e. 8 byte float. SSIS automtically cast them as DT_R8 which sounds correct.
I can preview the OLEDB data source in BIDS but when I run the package (again in BIDS), I get the error. I assume that the precision of the fields in the SQL table definition is higher than DT_R8 in SSIS but it is not clear to me what the precision needs to be to match DT_R8. I don't need high precision, it's just the default from when I created the table.Any thoughts as to why I am getting this