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.
| Author |
Topic |
|
mr_mist
Grunnio
1870 Posts |
 Posted - 2004-06-18 : 06:18:58
|
We're doing an Oracle to Sql Server DTS with the oracle ole db provider and one of the data pump tasks is failing and sayingStep Error Source: Microsoft Data Transformation Services (DTS) PackageStep Error Description:Catastrophic failureStep Error code: 8007FFFFStep Error Help File:sqldts80.hlpStep Error Help Context ID:4700 Now, a catastrophic failure sounds real bad like, but it's a fairly useless error message in terms of diagnosis. Anyone come across this? Solutions?-------Moo. :) |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-06-18 : 06:22:22
|
Ooh No!You've really bust it now Nah, I've had those errors before and then restarted the job a few minutes later and it would execute perfectly.I think the dba was busy doing something at the time.Duane. |
 |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-18 : 07:17:46
|
| that article seems to imply that you are running a really old MDAC, is that true?-ec |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-06-18 : 07:19:27
|
| I don't think that that applies, we're using the Oracle provider.-------Moo. :) |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-18 : 08:01:57
|
| Which Oracle drivers are you using and to which version of Orable??We had a few problems with the M$ Oracle drivers... |
|
|
|
|
|
|
catastrophic failure. eee!