SSIS vs Oracle connection

View previous topic View next topic Go down

SSIS vs Oracle connection

Post  TheNJDevil on Wed Oct 03, 2012 1:28 pm

I am finally ready to roll this SSIS project out and have run into an unforseen problem. When launching the package manually, everything runs just great, under 2 minutes to completion. Now that it is set up to run using a SQL Agent job, it hangs on a connection to Oracle. I spent a day trying to figure out why it would just hang. Tried it in 32bit mode, 64bit mode, nothing seems to make it work when running in a job.

Anyone had similar problems?

TheNJDevil

Posts : 68
Join date : 2011-03-01

View user profile

Back to top Go down

Re: SSIS vs Oracle connection

Post  Mike Honey on Wed Oct 03, 2012 11:44 pm

Hi NJDevil,

Hanging sounds unusual - normally I'd expect this to fail with some kind of clue after a timeout. How are you sure it's hanging on the Oracle connection?

BTW I feel your pain - Oracle connections can be a nightmare. The standard method still seems to rely on the good old tnsnames.ora file in the right place with the right content (usually manually edited) and the PATH environment variable to point to it. It all seems really "retro" for 2012 ...

Good luck!
Mike
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum