DTS package works, Job that invokes it doesn't

[gr8patra]

I have a DTS package that has an Active X task in it that calls a Crystal Report based on a stored procedure. When I execute the package the report runs fine and gets printed or e-mailed out. When I try to run the package through a job, I get an error saying that access to the report is denied, or another error (depending on the package - I have multiple ones) saying that the path to the report is not found. Do you happen to have any ideas of what might be wrong?

 

[MaxZak]

The difference between running a DTS directly and running it throught a job is that the latter runs with the privileges assigned to the login used to start the SQL Server Agent service. Try to check the settings of that user