Very Computer

by **gwj** » Sun, 20 Jun 1999 04:00:00

I have a dts package which imports an access table into sql server 7.0.
It runs manually from Enterprise Manager/DTS just fine.
When I create a dtsrun job and run it I get the error
'could not lock file'

I have been playing with file permissions and logins but am
just not getting it. Any help would be appreciated,

Thx,

Gary

by **Bill Hodghea** » Wed, 23 Jun 1999 04:00:00

Are you using DTSRun from the command line of from SQLAgent? The agent has
it's own security context and may not have access to your file.

Quote:> I have a dts package which imports an access table into sql server 7.0.
> It runs manually from Enterprise Manager/DTS just fine.
> When I create a dtsrun job and run it I get the error
> 'could not lock file'

> I have been playing with file permissions and logins but am
> just not getting it. Any help would be appreciated,

> Thx,

> Gary

Very Computer

dtsrun 'could not lock file' error

dtsrun 'could not lock file' error

dtsrun 'could not lock file' error