Yeah, check out the WROX books at that site.

Also make sure you are reading the latest blogs out there.

Just do a search on 'SSIS' or 'SQL Server Integration Services' and...

First off, guru or not this is an ongoing quest.

Design vs. business need. There is no way to prepare or develop for 100% of the changing scenarios.

On that matter...

I will try that out and do a little more research into the file. I think you are right in thinking the issue is somewhere inside the actual file.

I...

Just an update, I've tried a few more things and I still get stuck at the aforementioned total rows.

It seems like for some reason the process thinks it is done....

Nope. It just stops at the 59,933rd row. Says it completed.

My ROWTERMINATOR is actually set to ' \ n ' without spaces, I think it formatted it or something for the forum post. I'll try the suggestion to...

Could you clarify a bit more? When you say it won't fit into Excel, do you mean that the data is not entirely visible in the window or that...

Thanks for the input Matt.

So far I just did some basic old C# string parsing using the string object and string builder object. That is a remarkable improvement over...