Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Catastrophic Error on scheduling dts

Status
Not open for further replies.

drlex

Technical User
Jul 3, 2002
3,295
GB
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
 
Turns out this is an error resulting from the Openlink client software. An upgrade to 5.0 has overcome this problem. Posting to help anyone who later searches for this topic.
lex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top