SELECT *

FROM OPENQUERY(ORA_PRD,

'SELECT NAME, DIMORA.PK_TEST.TEST(ID, ''Hello'') FROM DUAL'

);

This works for me.

Maybe you should put the semicolon out of the query string.

With me it gave error.

Also, try using...

I'm importing a *.xls file with ACE 12.0, I didn't had this problem with *.xlsx.

I'm able (tested) to import both type of files with that provider.

What I want to avoid...

I believe there's an 32/64 bit option on SQL Agent 2008 to run DTSX in a job.

You can use the command line also and choose between dtexec.exe and dtexec32.exe

I believe...