"djyoda" wrote:

> Hi Everyone,
> I'm migrating a SQL Server 2000 instance to a new box running SQL
> Server 2005. I've installed the SQL 2000 DTS components on the new box
> which runs 2005 cause i need my existing DTS packages to keep running
> on the new box.
>
> I exported over the DTS packages, and am able to execute them
> successfully when i go to "Management" => "Legacy" => "Data
> Transformation Services" , opening the DTS package and executing them
> manually. However, when i scheduled the packages by going to "SQL
> Server Agent" => "Jobs" , the jobs keep failing. When i look at the
> "View History" screen, all it tells me is :
> =====================================================
> Message
> The job failed.
>
> Executed as user: <SQL AGENT USERNAME>. The package execution failed.
> The step failed.
> =====================================================
> This error msg doesnt help much. I'm guessing this issue has to
> something to do with user permissions...?
> I should state that, instead of running SQL Server Agent service as
> LocalSystem (which is not recommended), i created a new user , added
> the user to the Local Admin group and changed the SQL Server Agent
> Service to use this new user.
> I would really appreciate some help on this issue. I've got a deadline
> coming up in a couple of days, and this issue is the only pending one
> left. Please help !
>