Hey folks, sorry to pester you for help again, but I've got a pretty evil problem I could use a hand on ...

I need to throw a date parameter into a "Transform Data Task" going from a "Microsoft ODBC Driver For Oracle" connection to an SQL Server 2K connection.

The problem here is that no matter what format I put the damn Parameter into I get the following error

"Wrong Number Of Parameters"

Now, if I use the OLEDB driver for Oracle I can't even get that far.

I run into a SetParamInfo error.

if anyone knows how to fix EITHER issue, PLEASE let me know.

Your humble requestor,