SSIS 2008 painfully slow to import CSV
The 'answer' was that the ADO.Net providers in SSIS are basically useless and an embarrassment to the '.Net' moniker.  They flake at more than a few thousand rows and are so hobbled as to be effectively useless.  Basically, just stick to the old OLEDB providers and everything will be fine.