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