Home Forums SQL Server 2005 SQL Server 2005 Integration Services Flat File Source with Header and Footer Rows RE: Flat File Source with Header and Footer Rows
kbatta
SSCrazy
Points: 2274
More actions
December 4, 2008 at 4:32 pm
#908010
Where you read in the file, did you set the error handling to either ignore or reroute bad rows?
The next step should be a conditional split to only pass the rows you want to the rest of your processing.