Solved

Error Integration services connention Microsoft access

Posted on 2009-04-07
1
258 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:
udayakumarlm earned 500 total points
ID: 24087892
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

Suggested Solutions

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 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

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now