taphonomist
Programmer
I'm having some trouble with a scheduled package with SQL Server 2000. The package basically accesses and pumps data from an Access file that basically tracks usage of some machines, which I'd like to have a daily log of. As seems to be a pretty common problem, I'm able to execute the package, so long as it's not scheduled. When I set up a scheduled package, it gives me a permissions error (Cannot open file ... Exclusively locked or permissions needed). I've tried a number of things and nothing seems to help. One possible thing is that I'm running enterprise manager on my machine rather than the server, but as I understand it, when you save a package, the info is saved on the server??
taphonomist
taphonomist