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 to run my SSIS Package. Unfortunately I was not part of installation or anyone not aware of Installation path. So, I searched whole computer for "DTEXEC" unitily and it did work. So if you ever run into this problem loacate this file and past path it will do magic to you guys. Syntax will post latter. If you want you can always reach me out with your problem at rajesh@mcom.com
Tags:
running 32 bit ssis package on 64 bit server.
