Re: Scheduled Job Sometimes Error Sometimes Not

From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
Date: Thu, 28 Jul 2005 08:51:34 +0000 (UTC)

Resant (resant_v@xxxxxxxxx) writes:
> Thanks for your reply.
> The error that I've post is taken after I've checked "Show step
> details". OK, I'll post the error again completely :
>
> Executed as user: XXXX\xxxx. ...un OnStart:
> DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_6 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_10 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_10 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2
> DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_3 DTSRun OnStart: DTSStep_DTSDataPumpTask_2
> DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_4
> DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_4
> DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_4 DTSRun OnStart: DTSStep_DTSDataPumpTask_4
> DTSRun OnStart: DTSStep_DTSDataPumpTask_4 DTSRun OnStart:
> DTSStep_DTSDataPumpTask_4 DTSRun OnStart: DTSStep_DTS... Process
> Exit Code -1073741819. The step failed.

That's pretty anonymous. Unfortunately I don't know DTS, so I don't
have any suggestions to offer. Maybe the people in
microsoft.public.sqlserver.dts has any ideas.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.

References:
- Scheduled Job Sometimes Error Sometimes Not
  - From: Resant
- Re: Scheduled Job Sometimes Error Sometimes Not
  - From: Erland Sommarskog
- Re: Scheduled Job Sometimes Error Sometimes Not
  - From: Resant

Prev by Date: Re: Scheduled Job Sometimes Error Sometimes Not
Next by Date: Re: identity, plus pk?
Previous by thread: Re: Scheduled Job Sometimes Error Sometimes Not
Next by thread: Re: Scheduled Job Sometimes Error Sometimes Not
Index(es):
- Date
- Thread

Relevant Pages

Re: Getting all nodes and node details from xml using xquery
... Since I'm no specialist in XML, I've consulted my MVP colleagues who know ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: Trying to get Mgmt Studio to work as expected
... when it comes from a SQL Server MVP, ... The problem is that it is a very odd behaviour for an editor. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools)
Re: Physical reads
... Books Online should have some info on this. ... Tibor Karaszi, SQL Server MVP ... "Aaron Weiker" wrote in message ...
(microsoft.public.sqlserver.server)
Re: Search Between Times
... You find convert under the topic CAST and CONVERT in Books Online, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver)
Re: Time to shrink a database
... database, why should every person write their own and go through a ... SQL Server comes with maintenance plans where you can set this up, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)