I have a DTS package that is scheduled to run on the 2nd of each month. The main package runs several other packages to FTP, import, and transform data into SQL Server. This process has run successfully for 3 months until now.

The scheduled job's history shows the job failed immediately on execution with this error: The process could not be created for step 1 of job 0xFF0E3FB18319084AAA175C46A331C40B (reason: Overlapped I/O operation is in progress). No one else is accessing the files. The individual packages run fine and the master package runs fine. Only the scheduled job fails. I have deleted and recreated the scheduled job, but the job still fails

I'm at a loss. Any ideas
--Ange
--------------------------------------------
Every time I lose my mind, I wonde
if it's really worth finding.

In your job step fully qualify the path to DTSRUN.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"AngelWPB" <jduncan (AT) weissinc (DOT) com> wrote

data into SQL Server. This process has run successfully for 3 months until
now.
0xFF0E3FB18319084AAA175C46A331C40B (reason: Overlapped I/O operation is in
progress). No one else is accessing the files. The individual packages run
fine and the master package runs fine. Only the scheduled job fails. I have
deleted and recreated the scheduled job, but the job still fails.

In article <68A7B227-5B7F-488B-94FF-76E78D458183 (AT) microsoft (DOT) com>,
AngelWPB <jduncan (AT) weissinc (DOT) com> writes
Have a look at this past thread-
http://tinyurl.com/eeob

Does it help?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org