Solved

Error Integration services connention Microsoft access

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

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

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

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

756 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