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 |
|
hkuntal
Starting Member
3 Posts |
 Posted - 2007-12-21 : 05:10:00
|
| Hi All,I hav a strange problem. I created a SSIS package on my machine with protection level as "EncryptAllWithPassword".When I deploy this package on a SQL Server on another machine (either in File System or SQL Server)and add it as a job in SQL Server Agent and try to run it through a scheduler or manually the job fails with the following message - Executed as user:IBM-P4-1976\SYSTEM. The package could not be loaded. The step failed.However if I deploy it on my own machine the job runs successfully. Also if I run the package using dtexec utility on the another machine it runs successfully. It is not running as a job on another machine. All the logged in users have administrative rights. My databases are altogether on a different server.Can any one help me out with this issue...Pleassssseeee... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-12-21 : 13:05:56
|
| Refer this. might be of help:-[url]http://www.codeprof.com/dev-archive/16/19-84-163140.shtm[/url] |
 |
|
|
|
|
|
SSIS package not executing as a job.