DTS Scheduled Job Fails if Access Users are in MDB - 01-18-2005 , 10:51 AM
I have a scheduled job with 6 steps like
DTSRUN /s<SERVER> /e /n<DTSjobname_import_from_Access_MDB>
The job fails on these steps if users are in the Access system which the DTS
jobs import from. If no users are in, then the scheduled job runs fine.
If users are in the system the DTS jobs run manually fine.
I dont believe the answer is in the world-famous 269074 entitled INF:How to
Run DTS Package as a Scheduled Job though I may be wrong.
Re: DTS Scheduled Job Fails if Access Users are in MDB - 01-18-2005 , 01:05 PM
Well that would depend on the error <grin>
Are you getting along the lines of "You cannot get to this file because it
is being user by another process" or some such like?
I am no Access Expert but maybe one of these will help
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Andy at accession" <Andy at accession (AT) discussions (DOT) microsoft.com> wrote in
message news:A3F0A54F-2F92-4BDD-8286-ACE96AD8EF88 (AT) microsoft (DOT) com...