Hello All,
I have a DTS package on SQL2000 that of course runs
great in DTS builder. When I execute this package from the command line with:
dtsrun /s. /e /nPackage_Name
It works great but....
When I use this exact command with the SQL Jobs agent
it fails. I am sure it has to do with permissions but how do I work around it. I have read the M$oft article and I must be missing something.
Basically I have to give the SQL agent permission to connect over the network to my Access dbase but how?
I could run this job from the scheduler but that is not a very good solution in my opinion.
When I run from the command line I think it must use the
account the machine is logged in under?
But when I run it from SQL it must use some other account?
Thanks For Your Time
JB
I have a DTS package on SQL2000 that of course runs
great in DTS builder. When I execute this package from the command line with:
dtsrun /s. /e /nPackage_Name
It works great but....
When I use this exact command with the SQL Jobs agent
it fails. I am sure it has to do with permissions but how do I work around it. I have read the M$oft article and I must be missing something.
Basically I have to give the SQL agent permission to connect over the network to my Access dbase but how?
I could run this job from the scheduler but that is not a very good solution in my opinion.
When I run from the command line I think it must use the
account the machine is logged in under?
But when I run it from SQL it must use some other account?
Thanks For Your Time
JB
