Palash Mitra (3/8/2011)
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 a potential downside to this solution if the excel is too big.
Regards,
Palash.
Great! Glad that it worked out.
The TypeGuessRows setting can indeed affect performance very badly.
But if your Excel file is that large, I would suggest to convert it to .csv and import it as a flat file. Much more efficient.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP