Hi,

The environment is below:-

SQL Server 2000 Enterprise Edition 8.00.2055

Windows Server – Windows 2000 Advanced Server and Windows 2003 Server

　

　

We have a SQL Job that calls the DTS package using DTSRun command.

The job step is

DTSRun /F <DTS Package Name alongwith Full Path> /N <DTS Package Name> /M
<password> /A LanID:8="auto"

This SQL Job is executed from Windows 2000 Advanced Server as well as
Windows 2003 Server on SQL Server 2000 Enterprise Edition.

　

　

This SQL Job fails sporadically giving the following error:-

Executed as user: <username>. The step did not generate any output. Process
Exit Code -1073741819. The step failed.

The job failed. The Job was invoked by Schedule 8 (<step name>). The last
step to run was step 1 (<step name>).

　

　

We are able to run the SQL Job and DTS successfully after the job fails.

Running the job again after it has fail, does not result in error.

There is no specific or detail information in the Event Viewer log.

Please guide us in solving this issue.

Thanks.