SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
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  

Constraint Violating Yak Guru

396 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

Aged Yak Warrior

816 Posts

Posted - 03/19/2013 :  14:16:36  Show Profile  Reply with Quote

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

Constraint Violating Yak Guru

396 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.
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.12 seconds. Powered By: Snitz Forums 2000