My SSIS program reads as input from a .csv file.
The file has about 60,000 rows. And my SSIS package fails during the read, saying cannot convert a certain column due to potential loss of data.
Now, I am certain that the majority of the rows are correct. As I have tried pasting random subset of the file and the SSIS reads fine.
But I can't figure out a way to determine exactly on what line did my package fail.
I have spent 2 months on this problem, any advice?