Solved

ssis

Posted on 2011-03-20
2
374 Views
Last Modified: 2012-06-21
I am getting following error while transfering the data feom sqlserver 2000 to sqlserver 2008 using dataflow task in ssis:

 Error description:SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "SourceServer" failed with error code 0xC0202009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Please assist

Thx
Naren
0
Comment
Question by:knaren1975
2 Comments
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 35179049
Please make sure connection is well created.
0
 
LVL 9

Accepted Solution

by:
kaminda earned 500 total points
ID: 35179226
I think this is a credential issue. Does your SQL Server Agent runs using a network account? Also make sure the user you are running the SSIS package is a user has rights to both the databases.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
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…

860 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