Job fails

[a***@gmail.com]

Hi,

For DB Upgradation, I took the job script from SQL 2000
and executed in SQL server 2005. One of my job fails and getting the
below error.

" Non-SysAdmins have been denied permission to run DTS
Execution job steps without a proxy account. The step failed"

Can any one please help me how to resolve this?


Thanks,
Anitha

[tbradshaw via SQLMonster.com]

Hello Anitha,

Looks like you need to create a proxy account to handle this for you.
Perhaps this discussion will help you.

http://forums.databasejournal.com/archive/index.php/t-42543.html


Best Regards,
Tom Bradshaw

Thomas Bradshaw
Data Integration Services
MyWebGrocer LLC