I am importing a .csv file comma delimited to sql2008r2 and 2 of the columns are datebase timestamp. Some of the rows contain the value NULL and I receive the following error: "Error Data conversion failed. The data conversion for column "START_DTE" returned status value 2 and status text" The value could not be converted because of a potential loss of data".
Copy of the .csv record and the 2 NULLs before the datetime fields are START_DTE and END_DTE and in the table these are also database timestamp:
98-017 (Use),All of the warehouse,NULL,NULL,NULL,2
I have saved this to SSIS and included a screen shot.