Hello

I have a configuration where a Windows 2003 server with SQL 2000 SP3a and
Analysis Server 2000 SP3a is importing data from tables in an Oracle
database on another server.

The import process is managed through a DTS package which is run from a SQL
server job. The DTS package runs every minute or so to keep theMSSQL
database up to date with the Oracle server. There are about 25 tables
updated each time if data is present. The Oracle driver is the Microsoft
OLE/DB driver.

Each table is updated through a process where a Global properties task
determines the most recent date of MSSQL data and sets a Global Variable to
contain this date. An ActiveX task then creates a SELECT statement based on
the date returned in the previous step. Finally a data pump retrieves the
data from the Oracle server using the SELECT statement inserted by the
ActiveX step. After an initial "Log Start" step, there is a fan-out to 4
separate parallel paths to improve import flow efficiency.

This process works fine most of the time except that ocassionally the DTS
stops without error and completion. The Log Detail for the package shows
that the steps are all completed (with green ticks) but those that have not
really completed show a Run Status of 0. These is no error in the job log;
the job is just incomplete and never continues. There is nothing in the
event log to indicate what may be happening.

Any help on this one appreciated.

Thanks and regards
Chris Pulford