SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Excel not Supported in 64-bit SSIS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jbates99
Constraint Violating Yak Guru

351 Posts

Posted - 03/19/2013 :  13:54:33  Show Profile  Reply with Quote
hi experts,

My 2008 R2 package is on a 64 bit server.
It runs fune in BIDS but when I run it from an Agent job, I get the error below:

The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

I know the workaround is to run the package as a command.

My question is - is this issue fixed by SP1? My instance is RTM.

Thanks, Jack

jeffw8713
Aged Yak Warrior

USA
769 Posts

Posted - 03/19/2013 :  14:16:36  Show Profile  Reply with Quote
http://www.microsoft.com/en-us/download/details.aspx?id=13255
http://blog.oraylis.de/2011/05/ssis-goodie-1-excel-ssis-64-bit-dts_e_oledb_excel_not_supported/

There is also a check box on the agent job properties for these jobs where you can tell the process to run the 32-bit version.
Go to Top of Page

jbates99
Constraint Violating Yak Guru

351 Posts

Posted - 03/19/2013 :  14:59:18  Show Profile  Reply with Quote
Thanks jeffw8713. The 32 bit check box is the simplest option and works well.

If I can only remember to use that option when I face this issue again 6 months from now, LOL.
Jack
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000