March 11, 2016 at 5:42 am
Hi,
I am trying to run an SSIS package as a job. the package basically copies across data from excel spreadsheet to a SQL table. I can run the SSIS package successfully from the VS environment.
However, when trying to run the package as a job, it fails with the error - 'The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.'
I have tried to rectify this through all the below options, however nothing works and I don't have any further ideas left.
1. Checked box for “Use 32 bit runtime” on the Execution options tab on the Job Step page to run the package in 32-bit mode but still getting error.
2. In development, set the 32 bit runtime environment using Project Properties -> Debugging -> Run64BitRuntime = False but still getting error.
3. To make sure that the packages is run in 32-bit mode,I have also used the x86 version of dtexec and specifying the "/X86" switch.
"C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtexec.exe" /f "F:\My SSIS Packages\etlCL_Import_Excel.dtsx" /X86
Can somebody please advise on this please ? Thanks.
March 11, 2016 at 2:01 pm
Might be something in here for you: http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply