Error 80004206a, no error message   

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

date: Mon, 14 Jul 2008 14:11:02 -0700 (PDT)   author:   thursday's geek

Re: Error 80004206a, no error message   

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

date: Mon, 14 Jul 2008 14:22:46 -0700 (PDT)   author:   thursday's geek