I have one basic Question in SSIS Excel Connection Manager. I am using MS Excel 2007 as a source in my SSIS 2008 packages. It is workig fine. But when I deploy this into production i am getting some conection error(Excel not installed now). Do we need to Install Excel in Production Server? Or Is there any work around? ThanksLiyasker Samraj K

I don't think you need to install excel software on production server. There is no 64-bit driver for Excel. You need to run the 32-bit version of DTEXEC (located in C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn).http://uk.linkedin.com/in/ramjaddu

what is the error message exactly? http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

RamJaddu, I have not tried your answer , i will try update on this.. Thank you for the response. I am getting the below error Msg during the package Execution... Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTON FROM CONNECTION MANAGER. The AcquireConnection method call to the connection manager "ExcelInputFile" failed with error code 0xC0209302. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Error: component "DFT_ExcelSrc" failed validation and returned error code 0x020801C. Error: One or more components failed validation. Error: There were errors during task validation. Error: SSIS Error Code DTS_E_OLEDBNOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error code: 0x00000000. An OLE DB record is availabe. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered" Thanks, Liyasker Samraj K

Please read Interacting with Office. The short version: there is a 64-bit option, you don't need to install office, but you do need to install a driver. Talk to me now on

Thanks Todd and RamJaddu :) I installed only the MS offices driver and Execute the job in 32 Bit DTEXEC . Now it works fine. How to run the 32 Bit SSIS package in 64 Bit Environment? Please clike and refer the screenshots http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx Thanks, Liyasker Samraj K