Last row is a blank row in flat file destination SSIS Package

0
votes

An SSIS package exporting data to the flat file text. The exporting work fine, except for the blank row at the end of file. Is there a simple way to get rid of the blank row?

Ragged Right in Source and Destination Flat File Connection 9 Columns Defined with Appropriate Input Column Width and Output Column Width.

no header rows and last column delimiter CRLF.

Source

SOURCE File

Destination

Destination File

Thanks in advance. BV

1
flat-filessis-2008

1 Answers

-1
votes

Use a Conditional Split Transformation in between source and destination to remove empty rows from data flow pipeline. In the Split transformation editor specify boolean SSIS expression in Condition column something like

LEN([Col 1]) > 0 && LEN([Col 2]) > 0 ...

Or

ID != "" && [Col 1] != "" && [Col 2] != ""

Conditional Split