DTS periodic failures

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi,

I have a server running on Windows Server 2003 and SQL Server 2000 SP3a.

It runs 16 DTS packages scheduled to run once per minute via SQL Server
Agent. Periodically TDSRun will fail with the following message in a dialog
box.

The exception Illegal Instruction
An attempt was made to access an illegal instruction
(0xc000001d) occurred in the application at location 0x007d24b4

The execution of the job is blocked at that point. This has happened on a
number of DTS packages. All the packages on the server have a connection to
the local SQL Server and an SQL Task. All the packages operate on a linked
server in the SQL Task. There are several databases involved on the linked
server but each DTS package only accesses a single database. The linked
server runs NT 4 SP6a and SQL Server 7 SP3.

Any ideas about what may be causing this problem or any steps I can take to
try to diagnose the cause?

Regards

James Wilman

.

Relevant Pages

  • it all started on 5/27....
    ... individual DTS packages on SQL Server 2000 SP 4 that import and convert ... The SQL lives on a separate server than Pervasive. ... the same machine as SQL Server 2K SP 4. ... Now, if I execute the DTS packages individually on the server, all ...
    (microsoft.public.sqlserver.dts)
  • DTSRun Frequent Crashes
    ... It runs 16 DTS packages scheduled to run once per minute via SQL Server ... server but each DTS package only accesses a single database. ...
    (microsoft.public.sqlserver.dts)
  • DTSRun periodic problem
    ... It runs 16 DTS packages scheduled to run once per minute via SQL Server ... server but each DTS package only accesses a single database. ...
    (microsoft.public.sqlserver.dts)
  • Re: Reassigning DTS packages from one SS2K server to another
    ... approximately 45 complex DTS packages on the development server (lets ... I want to make a working copy of the database on a laptop computer ... The SQL Server is called LAPTOPSERVER. ...
    (microsoft.public.sqlserver.dts)
  • Re: Adding DTS via script
    ... As far as the DTS packages go, my source would be the structured storage file ... and the destination would be the sql server I wanted to add it to. ...
    (microsoft.public.sqlserver.dts)