RE: dts package error
- From: "Cynthia" <Cynthia@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Jun 2005 06:55:14 -0700
Donna,
IT fixed the permissions, now I get an error that the database is opened by
another user. No one else has access to the directory where the mdb file is?
Cynthia
"Donna Lambert" wrote:
> WhenEVER something works when kicked off manually, but fails through
> scheduler...suspect a permissions issue. When scheduled the package runs
> under the context of the SQL Agent account. Does the SQL agent account have
> rights to the directory that the file is in? Is SQL Agent even RUNNING under
> an account, or is it running under local system? Is the mdb on another
> server? If so, and the Agent is running under Local System, you'll either
> have to make sure you are running in an Active Directory and you've given the
> SQL server Machine account rights to the share and directory...or you will
> have to change SQL Agent to use a domain account.
>
> If SQL Agent is already starting under a user account, log in with that
> account and try to manually kick off the package.
>
> Also, turn on package logging (right click the background in designer,
> package properties, logging tab...error handling).
>
> Sorry if this seems like a lot of info.
> Let us know what you find out
> Donna Lambert
>
> "Cynthia" wrote:
>
> > created package through sql using the all tasks extract info selected a
> > mdb file on my server. then asked this to create a dts package and
> > scheduled it for once a week. when I run it manually I have no problem.
> > When it runs through the scheduler it cannot find the mdb file on the server.
> > What can I do to resolve this
.
- Prev by Date: Re: Importing Hyperlinks
- Next by Date: Re: How could I use a LookUp Query in a DataTransform Task to reach my goal?
- Previous by thread: How could I use a LookUp Query in a DataTransform Task to reach my goal?
- Next by thread: Newbie: Update From Excel
- Index(es):
Relevant Pages
|
