excel connection problem on a 64 bit machine
Hi, Iam running packages on SSIS 2008 R2 on a 64 bit machine.i have a master package which calls many child packages. one of the packages uses a excel sheet hence a it throws an error "Description: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Conne ction Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.End Error" Error: 2011-10-10 06:20:40.02. is it possibble to run the ssis package from command prompt on a 64 bit machine as 32 bit
October 10th, 2011 9:45am

Yes you can point 32-bit DTEXEC to run package see the below post http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/289e29ad-26dc-4f90-bad4-ffb86c76e5f9Shailesh, Please mark the post as answered if it answers your question.
Free Windows Admin Tool Kit Click here and download it now
October 10th, 2011 9:49am

Yes you can point 32-bit DTEXEC to run package see the below post http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/289e29ad-26dc-4f90-bad4-ffb86c76e5f9Shailesh, Please mark the post as answered if it answers your question.
October 10th, 2011 4:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics