Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Package Update Help

Status
Not open for further replies.
fmrock

fmrock

Programmer
Sep 5, 2006
510
0
0
US
We are moving one of our database's to a new server. This new server is SQL 2008 64bit, and the old was 2005 64bit.

Here is the error I am getting when I try to execute the package from Mgt Studio.

[Destination 1 - DDRAbbreviations [147]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SERVER-SQL-03.DBNAME.USER" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

When I test the connections from the Connection Manager, everything seems fine, however when we try to execute the package it give us this error.

Any ideas or help would be great!
 
Status
Not open for further replies.

Similar threads

TomaszB12
  • Locked
  • Question
Problem with package execution
Replies
1
Views
81
mark williams
mark williams
Cpreston
  • Locked
  • Question
Update File with only new records
Replies
1
Views
67
fredericofonseca
fredericofonseca
Sathia sankar
  • Locked
  • Question
SSIS Package which was sheduled thr
Replies
0
Views
66
Sathia sankar
Sathia sankar
Hardik Thakkar
  • Locked
  • Question
Memory Error - while iterating Execute Package Tasks Multiple times
Replies
0
Views
40
Hardik Thakkar
Hardik Thakkar
sidharth221
  • Locked
  • Question
SSIS package failing from autosys
Replies
0
Views
61
sidharth221
sidharth221

Part and Inventory Search

Sponsor

Back
Top