I receive flat data files from a vendor that are pipe delimited however
there is a header row and a trailer row that is not pipe delimited. The first row is easily bypassed however SSIS rightfully complains about the last row; “There is a partial row at the end of the file” Short of having a separate
process to strip the trailer record is there a way for SSIS to ignore this row?
Currently I am using a simple data flow with a flat file source and a
OLE DB destination (database) with the usual column mapping.
I can ascertain the data rows from the trailer row by the first character.
Data rows start with ‘D’ and the trailer row starts with ‘T’.
Thanks for any help!
View Complete Post