SQLTeam.com | Weblogs | Forums

Not reading all records from Flat File source


Hi Guys,

I need urgent help. I have one kind of simple SSIS package. Flat File source and SQL Table is a destination. My Source flat file has almost 5 million records. When I run my SSIS package its read only 121568 records. Why is it not reading whole 5 million records? I am sure my source file has almost 5 million records.

Please advise.

Thank You


Your file likely has data in it that is causing it think it reached the end, such as EOF or EOL characters.