SS08 SSIS pkg error

Run an SSIS pkg from a VS08 program.  Pkg includes Excel 2007 destination.  Using SS Agent get error "OLE DB provider Microsoft.ACE: OLEDB 12.0 is not registered."   Info found says to install Office 2007 driver...   my question:  install it on the server that the db is on?
McGurk1Asked:
Who is Participating?
 
Christopher GordonConnect With a Mentor Senior Developer AnalystCommented:
Try downloading the Microsoft Office Connectivity Components on the server that is running the SSIS package.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23734

(service pack)
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7020

This might resolve the issue.
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Hi,
If the above install didn't help, it could be a 64 BIT issue.
check that article for the solution

http://splents.com/2011/the-ole-db-provider-microsoft-ace-oledb-12-0-has-not-been-registered/

0
 
McGurk1Author Commented:
Thanks for the quick responses.  I have not had time to get back to this issue.  Will spend some time on it today and get back to you.
0
All Courses

From novice to tech pro — start learning today.