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) to copy the records 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

i've had this kind of problem before and it was due to rights.
Scheduled Jobs are run through the SQL Agent service, That service can start up using a different account than sql server.

Make sure the SQL agent account has rights. It also depends on what the package is doing. If it's sending mail through outlook than you need to have a profile available and the right login information...etc.

Hope this helps.


Al

Thanks Al_Dev..
So in my case, to scheduled the Jobs, i must use the sql server agent's Domain Account right?
And I don't have domain here. I just have workgroup.
So I can't set the Domain Account and can't scheduled the jobs.Am I right?
Thank you

moving to MS SQL Server forum...

Yes..you can use any windows account that has admin rights on that sql server. workgroup/domain are one in the same.
just in different context.
If your loginid is a "system administrator" on the sql server, you can use your id to run the service. Anyone with admin rights for that machine will do, don't have to have admin rights on the entire domain/workgroup unless the package is doing something special like accessing files on other machines or whatever.

does that make sense?

Clarification on:
"If your loginid is a "system administrator" on the sql server"
Should be:
If your loginid is "system administrator" on the machine that hosts the sql server/agent.

sorry for the confusion.