Solved

SS08 SSIS pkg error

Posted on 2011-09-07
3
282 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
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

770 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