SSIS Flat File Connection

[jj22171]

My SSIS package imports data from a text file. The Data Flow works fine until reaching a certain row and it gives out error message "[Flat File Source [1]] Error: An error occurred while processing file "myFile.txt" on data row 663207." Upon checking, data row 663207 is a blank row but not the end of file yet.

Is there a way around this error?

Appreciate your help.

jj22171

 

[JerryKlmns]

Import the file into a stage table of one field [varchar(4000)], delete the blank records and from there either export the table to a new flat file or modify your SSIS to use that table.