Hi Koen,
Was missing just that! Thanks a ton!
Went to registry and updated TypeGuessRows to 0; only this time @HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel.
And the dataflow worked just fine. However, there could be...