• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

SQL Server 2008 Exporting an Excel File

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.
0
tmaususer
Asked:
tmaususer
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
SSIS has known issues with connecting to Excel, and the biggest problem is that while Office moved up to 64-b it, SSIS stayed at 32-bit for a number of years.

I don't have an Excel-specific answer for you, but I strongly recommend avoiding the headache altogether and asking your data source to change the file to a flat file of some sort.

Good luck.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now