I am trying to import a csv file to a database table thru SSIS. In the file we have one date column and i have explicitly converted it to datetime in the package. But while execution, it extracts some records and then on one of them it throws an error of 'data conversion failed while converting....'

please help.

thanks