Error 80004206a, no error message

[Database Administrator]

I am trying to move data from a flat text file to an Oracle database,
using a DTS (it's a long story). I am using a DTS because some of our
servers are 2000 and some are 2005, so until everything is converted,
DTS is preferable to SSIS.

Right at the moment, I have a simple transform defined: one source (a
flat file, caret delimited), one destination (the oracle db), and the
transforms. When I try testing it, I get the following error:

HResult of 0x8004206a (-2147213206) returned
Unexpected error occurred. An error result was returned without an
error message.

Here is what I've checked so far:
-- I am supplying data for all required columns.
-- There are date fields that might be of the wrong format, so I'm
skipping those for now.
-- The account used on the destination does have rights to write to
the table.

I am going to remove all but the string to string transforms next --
perhaps there is some conversion error. But what other ideas should I
check out? The error message isn't exactly helpful. When I'm looking
at the individual transforms, and I do a test, each of them works
without error, so perhaps I'm on the wrong track by looking at
individual fields. I've been searching, and coming up empty. Any
ideas?

-thursday's geek

[Database Administrator]

It figures -- as soon as I post, I figure it out. It is the
transforms, because I removed all the non-character transforms, and it
worked. So, I just need to get all that (both date and numbers)
straightened out. I could whine about a non-useful error message, but
that's almost to be expected.

-thursday's geek

[withanat]

In DTS Package, you can goto properties for the step that fails, then Options, then Exception log (this logs the exceptions to a text file) to track down the cause of problem.

I had a similar issue with one of the dates being 28/9/0209 (Oracle did not complain). But MS SQL did NOT like it.

When I logged the exception to a text file, I managed to identify the entry that caused the error.

Hope this helps everyone who gets this weird error message.