Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kdrao12
Starting Member
1 Post |
 Posted - 2009-07-20 : 14:53:39
|
| Hi, I have a package which has a execute SQl task with ADO.net connection.This package was developed in a machine with sql 2005 x86 version and running fine when i call it through a job.Now i have moved the package to another machine where if i execute the package directly it succeeds but if i call the package through the job its failing.This machine has SQL 2005 x64 version.The error i am getting is:Code: 0xC00291EC Source: SQL Set SQL Variable with DELETE SQL Execute SQL Task Description: Failed to acquire connection "Target1". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error DTExec: The package execution returned DTSER_FAILURE (1).where Target1 is the ADO.net connection...What is the problem? |
|
|
jforward5
Starting Member
19 Posts |
Posted - 2009-07-21 : 15:22:53
|
| You need to give the new server ownership of the package. I had the same problem with a package I made a while back. Make sure that the user account you made it under is present on the new machine or that you assign a user with execute rights to the package on the new machine. |
 |
|
|
|
|
|
error when running package through job