ms sql server DTS

hi, i'd like to ask about the DTS in Sql Server.
I'd create the DTS in sql server(located at server PC), used to copy the records from sql server to access(located at client PC).
Then i executed the package, it is successful.
But when i scheduled the package as job, once hit the schedule time, the job failed.
Can anybody tell me the problem?
Thank you

The main reason for DTS Packages to fail when scheduled has to do with Security.

Make sure the schedule has a User and Password that can 1. Execute the DTS Package, and 2., has security to SQL Server and the Access Database.

Hope that helps.

Thanks...i'd try but still failed..
i think must set something in sql server agent...

I have had this same error... How did you fix it? I have my steps within the job retry once if they fail, and then they work. But only certain steps have to retry. Does anyone know why this happens???

hi,p_d.I not have a solution yet.So can't help me.
Hope you can tell me if you get the solution.
Thanks

I had similiar problems when i had packages that tried to access files on other machines. when you run the package yourself, your 're using your own windows login to access files on the other machine.

FYI. When you run jobs they are executed using the sql agent, which has its own nt login. Its usually the same as the current login (Local system)

if you add the login id of the sql server to a role on the other machine it will probably work. another alternative would be to start the sql agent service with another windows login that already has permissions to the other machine, like your id.



hope that helps.


Al