Step Error Description:Catastrophic failure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Step Error Description:Catastrophic failure

Author

Topic

reymon26
Starting Member

7 Posts

Posted - 2011-01-26 : 06:02:16

Hi there can anyone advise me what cause this failure ? why did it happen?

This is a dts package that transfer data from the oracle database to the sql server database.

i have attached the screenshot of the dts package..

here is the error log .. Does anyone know what cause this? and how to avoid this to happenned? thanks in advance..

The execution of the following DTS Package succeeded:

Package Name: TRANLN Batch Load
Package Description: DTS package description
Package ID: {AF6280CF-48E6-40D1-9CAB-24B7F3AE2279}
Package Version: {9F3E5184-1BAC-41AD-8993-8614A67AF1C4}
Package Execution Lineage: {DF0CDF27-245B-4133-B059-8D0F1CED77F9}
Executed On: USNSH-I-DB27
Executed By: SYSTEM
Execution Started: 1/21/2011 2:00:01 PM
Execution Completed: 1/21/2011 2:00:03 PM
Total Execution Time: 1.625 seconds

Package Steps execution information:

Step 'Copy Data from Results to [RBSSQL].[dbo].[TRANLN] Step' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Catastrophic failure
(Microsoft Data Transformation Services (DTS) Package (8000ffff): Catastrophic failure
)
Step Error code: 8000FFFF
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-01-26 : 09:07:51

This error typically means a connection error on the Oracle side. Does it happen every time? Can you connect to Oracle with Oracle client?

reymon26
Starting Member

7 Posts

Posted - 2011-01-26 : 09:19:22

hi russell,

upon checking the log files
the error was encountered 9/11/2008 , 2/3/2009 , 12/17/2010 , and this month again jan 16 , 2011 ,, thats why im thinking whats the cause of the error..

do you have an idea? or encountered this also?

reymon26
Starting Member

7 Posts

Posted - 2011-01-26 : 09:20:07

quote:
Originally posted by russell

This error typically means a connection error on the Oracle side. Does it happen every time? Can you connect to Oracle with Oracle client?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-01-26 : 09:27:17

I would try to see what's happening on Network or on Oracle server that may be preventing, or dropping the connection.

reymon26
Starting Member

7 Posts

Posted - 2011-01-26 : 09:35:32

quote:
Originally posted by russell

I would try to see what's happening on Network or on Oracle server that may be preventing, or dropping the connection.

any advise on what action can i do to know the root cause of this? and how to avoid this to happen again?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources