SQLTeam.com | Weblogs | Forums

Not reading all records from Flat File source


#1

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


#2

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