I am running sql server 2008 64 bit. I am trying to export an excel file into a table on a different server. I setup the export of the data via the wizard. I know I have setup every correctly as I have selected the run immediately check box in order to test and make sure my information is going from one server to the other. My issue is when I repeat the same steps but this time check save SSIS Package and continue with the wizard when I attempt to run the package via a scheduled job I receive the following error:
The Excel Connection Manager is not supported in the 64-bit version of SSIS<c/> as no OLE DB provider is available. End Error Code: 0xC020801C
I tried to change the execution options (tab) of the job and selected use 32 bit runtime but they did not do anything. Why did this work per my comment above until I actual attempted to create an SSIS package and schedule it as a job. Any help to solve is appreciated.