Re: Strange error when Executing an SSIS package from a SQL Job

On 13 Aug, 22:28, Hugh <H...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I should mention that "adminuser" in the error message is the windows admin
user I use to log in to the server with, not the SQL login that I created
that is set up to execute the job.

Hi,

I haven't seen this error before, but it does look like the package
isn't executing using the right credentials.
Check the Run As settings of the SQL Agent job that is created when
you schedule the package and make sure that it is set correctly for
each step.

Good Luck,
J

.

Relevant Pages

  • Re: Executing DTS from Code
    ... Now go to QA and execute the proc. ... Everything works fine on my development workstation which has SQL Server ... I moved the DTS package to the production server and ... runs the DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Execute DTS Package from C#
    ... If you want the package to execute actually ON the remote server then look at firing off a job that fores the package ...
    (microsoft.public.sqlserver.dts)
  • Re: Executing DTS from Code
    ... No one will be executing the code from the server, ... > and execute the proc. ... >> package. ... >> runs the DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Check connection to db
    ... The usual way would be to execute a dummy query against the server. ... If the connection is lost ... during package execution then the associated task will fail and you can set ...
    (microsoft.public.sqlserver.dts)
  • Re: ODBC Error when running DTS directly on the server
    ... Are you trying to execute this with a job? ... Did you try logging onto the server under your windows ... >I have just created some DTS package wich pump data from Visual FoxPro ...
    (microsoft.public.sqlserver.odbc)