I have several txts files in a folder and I am trying to convert those into my sql database.
There is no error message during the conversion however, it misses converting some lines in my txt.
It was showing that the total line number of the txt file was 8644 however after inserting into database, only 8631 shows up. I am so confused how can this happen?
[Flat File Source ] Information: The total number of data rows processed for file "E:\My_Txts\20093347.txt" is 8742.
[Flat File Source ] Information: The processing of file "E:\My_Txts\20093347.txt" has ended.
and then it shows
[DTS.Pipeline] Information: "component "OLE DB Destination" (9)" wrote 8730 rows.
View Complete Post