Package fails when run from Sql Server Agent

From: Rlane (rmathuln_at_pacbell.net)
Date: 12/07/04 

Date: 7 Dec 2004 14:18:50 -0800

I have a stored procedure that createz a DTS package on the fly using
the sp_OA... stored procs. The procedure copies data from a Sql table
into an Access .mdb file.

When the procedure is executed in a Sql Server Agent step, it inserts
rows into the Access file, but fails before finishing.
The logfile states that

Step error description : The number of failing rows exceeds the maximum
specified. (which is zero)
Step error code : 8004206A

Running the DTS package any other way succeeds (I save the package to a
structured storage file before it gets executed so that I can run it
other ways).

What would cause some rows to fail when using Sql Server Agent?
There's only one source table for all of teh data, so security is not
the issue.

Any clues?

Relevant Pages

  • Re: sql server agent job step that runs a dts package fails - urgent
    ... I have a stored procedure which runs for one and a half hours when executed ... dts package that gets run from sql server agent job. ... Now in test I cannot get the dts package step to run as it keeps failing ...
    (microsoft.public.sqlserver.dts)
  • RE: Problem using GLobal Variables in DTS Package
    ... > I have created a DTS package, the data source is a stored procedure with an ... > The source connection for the transformation uses Microsoft OLE DB Provider ...
    (microsoft.public.sqlserver.dts)
  • Problem using GLobal Variables in DTS Package
    ... I use SQL 2K on a Win2K box ... I have created a DTS package, the data source is a stored procedure with an ...
    (microsoft.public.sqlserver.dts)
  • Re: Output Parameter To Global Variable (DTS)
    ... DECLARE @OutputTest1 int, @OutputTest2 int ... I am executing a stored procedure with 2 input> parameters and 2 output parameters. ... > The output params are causing me a headache. ... When I execute the DTS task, only the first output param from the> stored procedure is populated into the global variable in the DTS package. ...
    (microsoft.public.sqlserver.dts)
  • RE: master..xp_cmdshell Error 997 from GetProxyAccount
    ... Start SQL Enterprise manager ... right mouse on SQL Server Agent and select properties ... select Job System tab ... > This all works when the stored procedure is fired inserting the record ...
    (microsoft.public.sqlserver.programming)