Re: Help Newbie - SSIS run in SQL server agent job

Hi Dennis,

90% of all "SSIS using SQL Agent" issues are caused by the SQL Agent
service account not having the correct permissions. SSIS packages run
using the credentials of the account that starts the package - in all
the other examples you've given (cmd line, powershell, running from
SSMS, etc) this will be using your credentials. When you SQL Agent
runs the job it will be using the SQL Agent service account.

That said, error message is a bit obscure ... however this is not
unusual for SSIS, and essentially what it's saying is it couldn't
connect. I'd say check the SQL Agent account permissions, and if you
still get this problem check the Package Protection Level (google) ..
this probably accounts for 70% of other connection issues ;)

Good luck!
J
.

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)
  • RE: dts package error
    ... under the context of the SQL Agent account. ... account and try to manually kick off the package. ... > When it runs through the scheduler it cannot find the mdb file 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: 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)
  • Re: Execute SQL Task starts to have problem after SQL2005 upgrade
    ... I got the same error when I run the package in development mode in MS Visual ... SSIS package "WebSignup.dtsx" finished: Success. ... the package as a job then it uses the service account credentials, ... from BIDS (assuming your user account has the correct permissions on ...
    (microsoft.public.sqlserver.dts)