i made it!.

it does not seem to be a 32/64 bit issue. The provider was using a MSDORA for oracle connection. when I changed it to OraOLEDB.Oracle. it worked...

there are some other jobs running on the same server with this type of connection

yes this works. think it is a new feature with 2005. thanks

how do I enable ssis service?

I think the remote conn is enabled otherwise, i did all my work from a remote management studio

i'm an admin on the box

 "Force Protocol Encryption" was always unchecked on my server but I still get this error.