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.
tmaususerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.