"Elizabeta" <Elizabeta@discussions.microsoft.com> wrote in message
news:051AACA5-2F01-43A6-A61A-81D3DA51B70C@microsoft.com...
> Thanks for the answer.
>
> I do not quite understand this
>
> > Make sure that Account
> > has the appropriate ACLs to access the file.
>
> But it is probably security matter.
>
> When I run it from the commandline DTSrun, it runs.
> (BTW: I understand all tricks of paths, database locations, server side. I
> am now working only on server...)
>
> But xp_cmdshell is failing the same as the job.
> error is:
>
>
> output
>
>
>
> --------------------------------------------------------------------------

> DTSRun: Loading...
>
> DTSRun: Executing...
>
> DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
>
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
>
> DTSRun OnStart: DTSStep_DTSDataPumpTask_1
>
> DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
>
> Error string: The Microsoft Jet database engine cannot open the file
''.
> It is already opened exclusively by another user, or you need permission
to
> view its data.
>
> Error source: Microsoft JET Database Engine
>
> Help file:
>
> Help context: 5003051
>
>
>
> Error Detail Records:
>
>
>
> Error: -2147467259 (80004005); Provider Error: -67568648 (FBF8FBF8)
>
> Error string: The Microsoft Jet database engine cannot open the file
''.
> It is already opened exclusively by another user, or you need permission
to
> view its data.
>
> Error source: Microsoft JET Database Engine
>
> Help file:
>
> Help context: 5003051
>
>
>
> DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
>
> DTSRun: Package execution complete.
>
> NULL
>
> (22 row(s) affected)
>
> Because I am trying to copy from an access database, from linked table.
This
> linked table is another access database and in production. But is not
locked
> exclusively. We are working through workgroup, and I already have set the
> workgroup location in registry (otherwise it wouldn't working at all.)
>
> I have not a solution for now, I just have to run it manualy.
>
> Any ideas?
>
>
> "Wm. Scott Miller" wrote:
>
> > Some things to try:
> > 1. Goto EM|Microsoft SQL Servers|SQL Server Group|[Server
> > name]|Management|SQL Server Agent and see if it is running (will have a
> > green play button icon). Then right click on it and see what account
the
> > service is running under (Properties|General tab). Make sure that
Account
> > has the appropriate ACLs to access the file.
> > 2. To get detailed error info, right click on the job in SQL Server
> > Agent|Jobs and choose "View Job History..." and make sure you have the
"Show
> > Step Detail" checked. Click on each failure and see what the messages
are.
> > 3. Remember that when you schedule a job, the job is totally running on
the
> > server. E.G. If no computer on your network is on except for SQL
Server, it
> > will run. So make sure the DTS task that you have designed takes this
into
> > consideration. E.G. If your access file is in your My Documents folder
on
> > your computer, trying to run it as a job will fail because that file
doesn't
> > exist in that location on the server. What I normally do is create an
> > identical folder structure on my computer and the server so I can run
the
> > tasks locally for testing and then just schedule them on the server and
they
> > will start to work.
> >
> > Scott
> >
> > "Elizabeta" <Elizabeta@discussions.microsoft.com> wrote in message
> > news:8FEFD984-242F-4C12-A2E6-A69372635345@microsoft.com...
> > > I have DTS package copying from Access 2000 database, from a linked
table,
> > to
> > > an SQL 2000 table.
> > >
> > > I can run the package independently, but when I schedule it, it is
> > > constantly failing.
> > >
> > > It is SQL server 2000, has service pack 3 installed.
> > >
> > > Anybody has some ideas.
> > >
> > > TIA
> >
> >
> >