Error Using CSV as source in DTS pacakge

[9654]

hi,
i have a CSV which has file type ANSI and {LF} as row delimiter and
double quote(") as text delimiter and comma(,) as column delimiter.
when i try to import using text file drive it fails after importing records for a while for weird reason saying

Error at source for row number 74555.
Errors encountered so far in this task:1.Column delimiter not found

This is weird because when i go and look at this line in the CSV in textpad the delimiter is very much there.
And this same error occurs for different CSV's at diff. row number.

any suggestions?

 

[9654]

i opened this csv in texpad and in the document properties it said
code set ANSI and file type UNIX so i saved it
as
file format PC and encoding ANSI and imported and it imported fine now i have to check the data.