Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Error Integration services connention Microsoft access

Posted on 2009-04-07
1
Medium Priority
?
268 Views
Last Modified: 2012-06-22
i have make a connection in integration services to Microssoft access, i use provider NATIVE OLE DB/MICROSOFT JET 4.0 OLE DP PROVIDER, (with and without user and password of admin), and made a DATA FLOW TASK to send rows from access to sqlserver table .But generate a eror:
" [OLE DB Source [99]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "MICONEXION" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed. "

Where is the problem?
0
Comment
Question by:rauljimenez
1 Comment
 
LVL 12

Accepted Solution

by:
udaya kumar laligondla earned 2000 total points
ID: 24087892
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

916 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