I have SSIS with SP1 installed. I also have the Oracle 10g client installed.

When I attempt to create a data source in an SSIS project for an Oracle
database, testing the connection returns "error initializing the provider ...
TNS error - no listener".

However, if I create a UDL file and specify the same OLEDB provider as I did
in SSIS and the same Oracle system - the connection test works fine (in the
UDL dialog - not in SSIS).

Any ideas on where I should look next?

Found it.

The Oracle client will always look first in your current working directory
for a TNSNAMES file - not in the default location (ADMIN directory).

I had an outdated TNSNAMES file out on a network drive which just happened
to be my working directory at the time I was testing.

One more chapter written in the "man do I hate Oracle" book....

"TheMadTexan" wrote: