Posted by Rajesh Setty on Thursday, February 18, 2010,
Hi All,
This is one heck topic which I cant forget to update on my website. I have spent two weeks figuring way of the this.
Problem: I have job scheduled to execute SSIS Package which imports data from Excel. It was failing with weired Messages.
How I Solved ? I searched web for resolution and found its problem with Connection Drivers. SQL Server 2005 64 Bit Version will not support any Excel Dataloads. This is statement from Microsoft, isn't it amazing ? And I was looking for "dtexec" Utility... Continue reading ...
