Hi,

I need some help to solve this problem. I have been
running this DTS package on a scheduled daily batch job on
SQL 7 Agent to pull data from an Oracle server. It has
been runnning fine since May 2003. Lately in December,
some tasks in the packages start to fail every day until
today, don't know why ? Below is the error message from
the log. The environment has not been changed since.

Can ANy one help on this ? Thank You in advance.


Package Steps execution information:

Step 'DTSStep_DTSDataPumpTask_1' succeeded
Step 'DTSStep_DTSDataPumpTask_2' succeeded
Step 'DTSStep_DTSDataPumpTask_3' succeeded
Step 'DTSStep_DTSDataPumpTask_4' succeeded
Step 'DTSStep_DTSDataPumpTask_4' succeeded
Step 'DTSStep_DTSDataPumpTask_5' failed

Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Backup, CHECKALLOC, bulk copy,
SELECT INTO, and file manipulation (such as CREATE FILE)
operations on a database must be serialized. Reissue the
statement after the current backup, CHECKALLOC, or file
manipulation operation is completed.
Step Error code: 80040E21
Step Error Help File:
Step Error Help Context ID:0

Step 'DTSStep_DTSDataPumpTask_6' succeeded

You are probably doing a

1. BACKUP of the database
2. DB Maintenance


at the same time and the BULK COPY is not allowed at the same time as this
operation.

Either reschedule the package or the other operation

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Thong K C" <kcthong (AT) staff (DOT) singnet.com.sg> wrote

You are right, the Database backup caused the DTS tasks to
fail. Thank for your help.