Solved

SS08 SSIS pkg error

Posted on 2011-09-07
3
286 Views
Last Modified: 2012-05-12
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?
0
Comment
Question by:McGurk1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 14

Accepted Solution

by:
Christopher Gordon earned 500 total points
ID: 36497169
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
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 36498063
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
 

Author Comment

by:McGurk1
ID: 36511289
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

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question