Link to home
Start Free TrialLog in
Avatar of George Contrabass
George ContrabassFlag for United States of America

asked on

Preventing empty records from importing in SSIS

?In SSIS can I prevent importing completely empty?

Here is one of 992 identical records:


The delimiter is the pipe symbol and there is a LF at the end of each line.

These appear at the end of more than 102,000 records.

Is there a way to prevent importing these files before I try and fail to process them?

I know how I can delete these records in TSQL.

Is there a way to have SSIS prevent them coming in?

Thank you.

Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial