RE: dts package error

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
.

Relevant Pages

  • RE: dts package error
    ... "Donna Lambert" wrote: ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
    (microsoft.public.sqlserver.dts)
  • DTS job fails if scheduled on VB email step.
    ... windows scheduler and a batch file, it fails with the error below. ... Microsoft Data Transformation Services Package ... Outlook is installed on the server. ... I am logged in as the SQL Agent domain account on the server. ...
    (microsoft.public.sqlserver.dts)
  • RE: dts package error
    ... database on a different server with information on my SQL once a week. ... > under the context of the SQL Agent account. ... > account and try to manually kick off the package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Help Newbie - SSIS run in SQL server agent job
    ... 90% of all "SSIS using SQL Agent" issues are caused by the SQL Agent ... service account not having the correct permissions. ... still get this problem check the Package Protection Level.. ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing a DTS package with "AT" command
    ... I have an ActiveX script within a DTS package that executes every 30 minutes ... account as the SQL agent but scheduling with the AT command appears not to ... allow the package to run under the SQL agent. ...
    (microsoft.public.sqlserver.dts)