Hello,
I'm trying to schedule a dts package which runs perfectly when executed manually, but fails on scheduling. Error is:
Step 'Copy Data from Results to Results Step' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Catastrophic failure
Step Error code: 8007FFFF
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4700
The Executed By fields are identical for the manual and scheduled events.
(Using SQL Server 2000 on MS Server 2000 with Openlink ODBC connection against a Progress 91d DB on a Unix system)
I've tried saving it as a stored procedure and calling it with an EXEC command, but same problem.
I'm a novice on SQL Server, so hopefully it's a simple error. Any thoughts & suggestions welcome
Many thanks,
lex
I'm trying to schedule a dts package which runs perfectly when executed manually, but fails on scheduling. Error is:
Step 'Copy Data from Results to Results Step' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Catastrophic failure
Step Error code: 8007FFFF
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4700
The Executed By fields are identical for the manual and scheduled events.
(Using SQL Server 2000 on MS Server 2000 with Openlink ODBC connection against a Progress 91d DB on a Unix system)
I've tried saving it as a stored procedure and calling it with an EXEC command, but same problem.
I'm a novice on SQL Server, so hopefully it's a simple error. Any thoughts & suggestions welcome
Many thanks,
lex